Re: OWNER TO on all objects - Mailing list pgsql-hackers

From Tom Lane
Subject Re: OWNER TO on all objects
Date
Msg-id 21244.1087392391@sss.pgh.pa.us
Whole thread Raw
In response to Re: OWNER TO on all objects  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> There is one other consideration, and that is that current pg_dump likes 
> to set session_auth to user of object before outputting drop command, 
> when '-c' is specificed.

> I propose that we eliminate that set session_auth as well.  If the user 
> running the script is the owner of that object or a superuser, then they 
> will be able to drop it.  If they are neither, then the drop will fail, 
> but the session_authorization would have failed anyway!

Seems reasonable.  The -c option is pretty badly thought out anyway :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OWNER TO on all objects
Next
From: Bruce Momjian
Date:
Subject: Re: Improving postgresql.conf