Re: Extending System Views: proposal for 8.1/8.2 - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Extending System Views: proposal for 8.1/8.2
Date
Msg-id web-6938704@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Extending System Views: proposal for 8.1/8.2  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Extending System Views: proposal for 8.1/8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Extending System Views: proposal for 8.1/8.2  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-hackers
Jim,

> Just to be clear, I'm not suggesting renaming anything in any of the
> existing pg_catalog objects. I'm suggesting creating a new, easier to
> use set of views that would sit on top of pg_catalog.

I have no objection to using easier to read names for the system views.(This is the user-friendly views, folks, not the
actualsystem
 
objects!).   The reason I suggested the names I did was to be
consistent.

Thing is, at least for the next version, if we are changing the naming
conventions, we need to leave the old views alone, at least for one
version (pg_tables, pg_views, etc.).  This means a new view name scheme
for the new views.  Suggestions?  

I might suggest simply "tables" "triggers" "types" etc.   The plurals
of these reserved words are no, AFAIK, reserved.  And if users are
creating identically named objects in public, they just need to
remember to use the schema.

Oh, also for the "Parameters (array)" etc.?   I was planning on having
text names there, *not* an array of OIDs or whatever.   The purpose of
these views is to be user-friendly.

--Josh


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Much Ado About COUNT(*)
Next
From: Tom Lane
Date:
Subject: Re: Extending System Views: proposal for 8.1/8.2