After upgrading from postgres 7.x.x to 8.1.0, my database restore
produces the following error msgs. The database is quite pedestrian:
a dozen or so tables, couple of triggers, some comments, &c. Note
that even though I get the following errors, a '\dt+' returns the
comment strings. Ar
Scott Frankel <[EMAIL PROTECTED]> writes:
> After upgrading from postgres 7.x.x to 8.1.0, my database restore
> produces the following error msgs.
> SCHEMA public postgres
> pg_restore: [archiver (db)] could not execute query: ERROR: must be
> owner of schema public
> Command was: COMMEN
Voila, 2. Executed as superuser and, yes, no errors.
Thanks again!
Scott
On Nov 10, 2005, at 3:51 PM, Tom Lane wrote:
Scott Frankel <[EMAIL PROTECTED]> writes:
After upgrading from postgres 7.x.x to 8.1.0, my database restore
produces the following error msgs.
SCHEMA public postgre