Sunday, September 28, 2008

Re: [HACKERS] Proposal: move column defaults into pg_attribute along with attacl

Markus,

* Markus Wanner (markus.wanner@programmfabrik.de) wrote:
> What does the subobject column for pg_shdepend buy us?

Tracking column-level ACL dependencies rather than having those
dependencies only be at the table-level. This complicates
pg_shdepend some, but simplifies the dependency handling in the
ACL area and in handling table/column drops.

I'm still not a fan of having column-level deps handled
differently between pg_shdepend and pg_depend, but that's not
something which has to be addressed directly by the column-level
privs patch. Perhaps once it's done I'll do a proof-of-concept
for removing pg_attdef.

Thanks,

Stephen

No comments: