| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fixing pg_dump |
| Date: | 2004-06-28 03:52:52 |
| Message-ID: | 40DF9614.5050502@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-06-28 03:53:48 | Re: lock timeout patch |
| Previous Message | Satoshi Nagayasu | 2004-06-28 03:28:13 | lock timeout patch |