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

From Tom Lane
Subject Re: OWNER TO on all objects
Date
Msg-id 25718.1087275059@sss.pgh.pa.us
Whole thread Raw
In response to Re: OWNER TO on all objects  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: OWNER TO on all objects
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I just inserted the ALTER OWNER statement between the CREATE and the 
> GRANTs.  Why do you want them at the end of the dump?

So that the initial owner is still owner when he does COPY, ALTER TABLE
ADD PRIMARY KEY, etc etc.  Else you're gonna have problems.

The regression database is next to useless as a testbed for this,
btw, since all the objects in it are owned by the superuser anyway.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: OWNER TO on all objects
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: OWNER TO on all objects