Re: error msg when pg_restore

"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