Re: More Cleanup Guidance Needed

On 02/03/2011 10:42 AM, Rich Shepard wrote:
> In the pg_dump file of the database are these lines:
>
> --
> -- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner:
> postgres
> --
>
> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
> LANGUAGE c
> AS '$libdir/plpgsql', 'plpgsql_call_handler';
>
> The last one is line #29.
>
> When I restore from the dumped file I see this error:
>
> psql:wqdb.sql:29: ERROR: function "plpgsql_call_handler" already exists
> with same argument types
>
> What, if anything, should I do about this?
>
> Rich
>

Ignore it or use the --clean option to pg_dump (which adds the
appropriate DROP commands to the dump file). The assumption without
--clean is that you are doing a bare metal restore.