Re: permission errors for set authority and schema public

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: permission errors for set authority and schema public
Date: 2003-11-30 10:08:48
Message-ID: Pine.LNX.4.44.0311301108280.11144-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony 2003-11-30 10:38:31 Re: PostgreSQL Advocacy, Thoughts and Comments
Previous Message Chris Travers 2003-11-30 09:45:17 Re: Was: Triggers, Stored Procedures, PHP