[GENERAL] pg_restore errors

2005-11-10 Thread Scott Frankel
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

Re: [GENERAL] pg_restore errors

2005-11-10 Thread Tom Lane
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

Re: [GENERAL] pg_restore errors

2005-11-10 Thread Scott Frankel
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