Re: Proposal: move column defaults into pg_attribute along with attacl - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Proposal: move column defaults into pg_attribute along with attacl
Date
Msg-id 20080923135535.GE16005@tamriel.snowman.net
Whole thread Raw
In response to Re: Proposal: move column defaults into pg_attribute along with attacl  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposal: move column defaults into pg_attribute along with attacl  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Markus Wanner <markus@bluegap.ch> writes:
> > ISTM that we should at least combine defaults and ACLs then, as proposed
> > by Stephen.
>
> Huh?  Maybe I missed something, but I didn't think that was suggested
> anywhere.

I had suggested a single table, with an OID, which would house anything
that needed a seperate OID for columns (defaults and ACLs currently) in
20080922024129.GD16005@tamriel.snowman.net.  It's not a completely
thought-through solution, just something that struck me as a more
general way of handling these situations (assuming we have more in the
future and don't want to give each one its own table).  If putting them
together implies we have to complicate things to add some way to
seperate them then it might not be worth it.  Having a seperate table
for each means we can use the table's OID to seperate them though.  I
still dislike this possible continued growth of the catalogs.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Initial prefetch performance testing
Next
From: Tom Lane
Date:
Subject: Re: pg_type.h regression?