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: jdrake@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 <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +