Re: OWNER TO on all objects

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: OWNER TO on all objects
Дата
Msg-id
40CE8519.7080101@familyhealth.com.au
Ответ на
Список
Дерево обсуждения
OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Peter Eisentraut <peter_e@gmx.net>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Peter Eisentraut <peter_e@gmx.net>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Peter Eisentraut <peter_e@gmx.net>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Peter Eisentraut <peter_e@gmx.net>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: OWNER TO on all objects Tom Lane <tgl@sss.pgh.pa.us>
Re: OWNER TO on all objects Christopher Kings-Lynne <chriskl@familyhealth.com.au>
> 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

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: OWNER TO on all objects
От: Christopher Kings-Lynne
Дата:
Сообщение: #postgresql report
FAQ