Re: Fixing pg_dump - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Fixing pg_dump
Date
Msg-id 40DF9614.5050502@familyhealth.com.au
Whole thread Raw
In response to Re: Fixing pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Yeah, that's still on my should-fix-for-7.5 list (and I think Fabien was
> going to, or already did, submit some ACL-hacking code to help).  That
> is, ALTER OWNER should adjust the ACL so that grants made by/to the
> former owner now appear to be by/to the new owner.
> 
> However, there's still the problem that a dump from a 7.4 or older
> database might exhibit the inconsistent ACL entries.  Not very sure
> how to cope ...

How about "if the grant is to user blah, from user blah and blah is not 
the owner of the object, grant as default user, not user blah"?

Chris



pgsql-hackers by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: lock timeout patch
Next
From: Tom Lane
Date:
Subject: Re: lock timeout patch