Prepping to break every past release... - Mailing list pgsql-hackers

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 nullrelnamespace   | 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