dmitigr=> create schema test;
CREATE SCHEMA
dmitigr=> create table test.test();
CREATE TABLE
dmitigr=> table "test.test";
ERROR: relation "test.test" does not exist
LINE 1: table "test.test";
^
dmitigr=> table test.test1;
ERROR: relation "test.test1" does not exist
LINE 1: table test.test1;
Shouldn't be first error looks like:
ERROR: relation ""test.test"" does not exist
LINE 1: table "test.test";
^
(with quoted relation name *as specified in the query*)
I've spend some time to find a bug in the application,
which performed query with entire quoted schema-qualified
relation name (i.e. "schema.relation" instead of "schema"."relation"
or just schema.relation), and the error handler printed to the log an
error message a confusing message.
Thoughts?
--
// Dmitriy.