Re: Proposed TODO: CREATE .... WITH OWNER;

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposed TODO: CREATE .... WITH OWNER;
Date: 2004-10-24 01:26:29
Message-ID: 4267.1098581189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Dennis and I are hashing this out on IRC. The second option would be to
> simply put SET SESSION AUTHORIZATION statements before each and every
> statement in the pg_dump. This would make each statement "atomic" as far as
> user ownership is concerned, with less changes than "WITH OWNER" would
> entail.

Uh, isn't that how we did it before? Why is that better?

>> Not in 8.0.

> Of course not. I'm talking for 8.1, or later.

No, you misunderstood me. The bug of which you are complaining (namely,
ALTER OWNER not fixing the ACL list) is gone in 8.0; therefore you are
arguing from a faulty premise about whether this change is needed.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2004-10-24 02:24:52 Re: Proposed TODO: CREATE .... WITH OWNER;
Previous Message Scott Marlowe 2004-10-24 01:06:21 Re: [GENERAL] Question on the 8.0Beta Version