More Cleanup Guidance Needed

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: More Cleanup Guidance Needed
Date: 2011-02-03 18:42:17
Message-ID: alpine.LNX.2.00.1102031040040.25032@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

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

Responses

Browse pdxpug by date

  From Date Subject
Next Message Michael Ewan 2011-02-03 18:52:58 Re: Syntax Error?
Previous Message Rich Shepard 2011-02-03 18:38:58 Re: Syntax Error?