Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

Next:From: Michael EwanDate: 2011-02-03 18:52:58
Subject: Re: Syntax Error?
Previous:From: Rich ShepardDate: 2011-02-03 18:38:58
Subject: Re: Syntax Error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group