Re: Get rid of system attributes in pg_attribute?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Get rid of system attributes in pg_attribute?
Date: 2005-02-21 09:23:53
Message-ID: 4219A8A9.5000700@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2005-02-21 10:31:59 slow mail server ?
Previous Message Jeff Davis 2005-02-21 06:37:13 Re: Transaction Aborted