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: (view raw, whole thread or download thread mbox)
Lists: pdxpug
   In the pg_dump file of the database are these lines:

-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner:

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
     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?



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-2017 The PostgreSQL Global Development Group