If this is the worst inconsistency you can find in our system tables after +20 years of development, I feel pretty good.
--------------------------------------------------------------------------- Joshua D. Drake wrote: > Hello, > > Something that continues to grind my teeth about our software is that we > are horribly inconsistent with our system catalogs. Now I am fully and > 100% aware that changing this will break things in user land but I want > to do it anyway. In order to do that I believe we need to come up with a > very loud, extremely verbose method of communicating to people that 8.5 > *will* break things. > > It seems to me that the best method would be to follow the > information_schema naming conventions as information_schema is standard > compliant (right?). > > Thoughts? > > Examples: > > postgres=# \d pg_class > Table "pg_catalog.pg_class" > Column | Type | Modifiers > ----------------+-----------+----------- > relname | name | not null > relnamespace | oid | not null > [...] > > postgres=# \d pg_tables > View "pg_catalog.pg_tables" > Column | Type | Modifiers > -------------+---------+----------- > schemaname | name | > tablename | name | > > postgres=# \d pg_stat_user_tables > View "pg_catalog.pg_stat_user_tables" > Column | Type | Modifiers > ------------------+--------------------------+----------- > relid | oid | > schemaname | name | > relname | name | > > > postgres=# \d information_schema.tables > View "information_schema.tables" > Column | Type | > Modifiers > ------------------------------+-----------------------------------+----------- > table_catalog | information_schema.sql_identifier | > table_schema | information_schema.sql_identifier | > table_name | information_schema.sql_identifier | > > > -- > PostgreSQL - XMPP: jdr...@jabber.postgresql.org > Consulting, Development, Support, Training > 503-667-4564 - http://www.commandprompt.com/ > The PostgreSQL Company, serving since 1997 > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
