Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group