Re: error msg when pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: error msg when pg_restore
Date
Msg-id 11891.1156281850@sss.pgh.pa.us
Whole thread Raw
In response to error msg when pg_restore  ("nuno" <wegein@gmail.com>)
Responses Re: error msg when pg_restore  ("nuno" <wegein@gmail.com>)
List pgsql-general
"nuno" <wegein@gmail.com> writes:
> when i restore a database (using a backup file), it shows me some error
> messages which do not seem to matter at all (there is no data lost in
> the database, and maybe they're just warning messages...).

> pg_restore: [archiver (db)] could not execute query: ERROR:  function
> public.plp
> gsql_validator(oid) does not exist
>     Command was: DROP FUNCTION public.plpgsql_validator(oid);

Apparently you're using the -c option when there's not really anything
that needs dropping.  -c is for removing existing copies of the database
objects you're restoring.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: using deferred initially deferred to solve foreign key checking issues
Next
From: Tom Lane
Date:
Subject: Re: varchar(n) vs. varchar