PostgreSQL error code
PostgreSQL error 42704
42704 is the SQLSTATE PostgreSQL reports for undefined object, in class 42, Syntax Error or Access Rule Violation.
| SQLSTATE | 42704 |
|---|---|
| Condition name | undefined_object |
| Class | 42 — Syntax Error or Access Rule Violation |
Reproduce it, then fix it
PostgreSQL has no type called double; it’s double precision. Other names from MySQL or SQL Server hit the same error, such as datetime (timestamp) and tinyint (smallint). Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
ALTER TABLE products ADD COLUMN weight double;
ALTER TABLE products ADD COLUMN weight double precision; SELECT name, weight FROM products LIMIT 3;