On Tue, Sep 26, 2006 at 12:35:54PM +0100, Heikki Linnakangas wrote:
> Tom Lane wrote:
> >>We could rename pg_attribute as pg_userattribute, and remove all the
> >>system attributes from that. To stay backwards-compatible, we could have
> >>a pg_attribute view on top of that contained the system attributes as
> >>well.
> >>
> >
> >I don't really think this is necessary. How many client programs have
> >you seen that don't explicitly exclude attnum<0 anyway? The places that
> >will need work are inside the backend, and a view won't help them.
> >
>
> None, there probably isn't any client programs like that. It would be
> nice for programs to be able to discover what system attributes there
> is, though.
+1; we need to have some way for users to find that info out, and I
can't think of a better way than pg_attribute.
If we want to create a set of views that are more human friendly I'm all
for it (it's why we started the newsysviews project afterall), but I
don't know if y'all want to open that can of worms back up.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)