Re: Get rid of system attributes in pg_attribute? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Get rid of system attributes in pg_attribute?
Date
Msg-id 4219A8A9.5000700@familyhealth.com.au
Whole thread Raw
In response to Get rid of system attributes in pg_attribute?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Get rid of system attributes in pg_attribute?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
> I'm wondering how useful it is to store explicit representations of the
> system attributes in pg_attribute.  We could very easily hard-wire those
> things instead, which would make for a large reduction in the number of
> entries in pg_attribute.  (In the current regression database nearly
> half of the rows have attnum < 0.)  I think the impact on the backend
> would be pretty minimal, but I'm wondering if removing these entries
> would be likely to break any client-side code.  Does anyone know of
> client code that actually pays attention to pg_attribute rows with
> negative attnums?

Well, apart from a "attnum > 0" clause in phpPgAdmin, I don't think so...

Chris


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Transaction Aborted
Next
From: Oleg Bartunov
Date:
Subject: slow mail server ?