Re: pg_restore - problems restoring the data - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore - problems restoring the data
Date
Msg-id 20217.1171636116@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore - problems restoring the data  (Arindam <arindam.mukerjee@gmail.com>)
List pgsql-general
Arindam <arindam.mukerjee@gmail.com> writes:
> In all the above cases, this is the error I get:

> pg_restore: [archiver (db)] could not execute query: ERROR: cannot
> drop schema public because other objects depend on it
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
>     Command was: DROP SCHEMA public;

Don't use the -c option.  Or else don't load your private additions
until after you restore.

            regards, tom lane

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: ROLE INHERIT
Next
From: Bjørn T Johansen
Date:
Subject: Re: Problem writing sql statement....