Re: OWNER TO on all objects

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: OWNER TO on all objects
Date: 2004-06-15 05:11:53
Message-ID: 40CE8519.7080101@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.

I was thinking of doing all COPY and ALTER as superuser as well...

Or are you trying to make it work when run as non-super? Which is won't
since ALTER OWNER will require superuser.

ie. the entire script always runs as a single user, most usefully a
superuser.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-06-15 06:25:06 #postgresql report
Previous Message Tom Lane 2004-06-15 04:50:59 Re: OWNER TO on all objects