On 28.08.2013 05:01, syxj...@gmail.com wrote:
postgres=# create table pg_class(a int); CREATE TABLE postgres=# insert into pg_class values (1); ERROR: null value in column "relnamespace" violates not-null constraint DETAIL: Failing row contains (1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).
That's not a bug. The table created is in the public schema, while all the system tables are in pg_catalog schema. Yes, it's possible to create a table in another schema with the same name. To avoid hijacking applications that access the system tables, pg_catalog is implicitly in front of search_path, if it's not listed there explicitly. So when you do the insert, it refers to pg_catalog.pg_class.
- Heikki -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
