PostgreSQL error code
PostgreSQL error 0A000
0A000 is the SQLSTATE PostgreSQL reports for feature not supported, in class 0A, Feature Not Supported.
| SQLSTATE | 0A000 |
|---|---|
| Condition name | feature_not_supported |
| Class | 0A — Feature Not Supported |
Reproduce it, then fix it
PostgreSQL reads a three-part name as database.schema.table, and one connection can only query its own database. Connect to the other database, or reach it through the postgres_fdw or dblink extension. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SELECT count(*) FROM otherdb.public.customers;
SELECT count(*) FROM demo.customers;