Re: SET SESSION AUTHORIZATION permissions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luís Sousa <llsousa(at)ualg(dot)pt>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SET SESSION AUTHORIZATION permissions
Date: 2006-09-04 15:18:23
Message-ID: 24366.1157383103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?ISO-8859-1?Q?Lu=EDs_Sousa?= <llsousa(at)ualg(dot)pt> writes:
> Only superuser can issue the command SET SESSION AUTHORIZATION?

Well, yeah.

> When I tried to dump and the restore on command line with my user, is
> issued a SET SESSION AUTHORIZATION with a permission denied error!

Use --no-owner if you want to make pg_dump output that won't generate
this error (and want all the restored objects to be owned by whoever
runs the script). Or just ignore the error messages.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafaqat Ali 2006-09-05 14:33:14 Automating pg-admin
Previous Message Luís Sousa 2006-09-04 11:14:30 SET SESSION AUTHORIZATION permissions