Postgres Pro
Downloads
Home   >   mailing lists

Re: permission errors for set authority and schema public - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: permission errors for set authority and schema public
Date
Msg-id Pine.LNX.4.44.0311301108280.11144-100000@peter.localdomain
Whole thread Raw
In response to permission errors for set authority and schema public  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
CSN writes:

> I upgraded to 7.4 a few days ago and am getting these
> errors when importing dumps: "permission denied to set
> session authority" and "permission denied for schema
> public". Not all of the dump is imported successfully.

Looks like you need to restore as superuser.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: "Chris Travers"
Date:
Subject: Re: PostgreSQL Advocacy, Thoughts and Comments
Next
From: "Chris Travers"
Date:
Subject: Re: Was: Triggers, Stored Procedures, PHP