On Wed, 14 Jan 2004, Tom Lane wrote:
> > The line from the sql file that is failing, a dump, is
> > SELECT pg_catalog.setval('invoicesdetails_invoicesdetailsid_seq', 18,
> > true);
>
> You have not given us any context to interpret this report in, but
> I do not think it has anything to do with the ownership of the public
> schema.
I need to dump/restore frequently from one database/machine to other
database/machines.
I did the dump as a regular user and was trying to do the restore as the
same user, but to another DB. Both DBs are owned by the user I did the
dump with.
Should restores be always done by the super user?