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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
