Can't reload dump - Mailing list pgsql-cygwin

From TimothyReaves@westfieldgrp.com
Subject Can't reload dump
Date
Msg-id OFF2A9E682.661E8D0E-ON85256B7B.004FADA1@westfield-cos.com
Whole thread Raw
Responses Re: Can't reload dump
List pgsql-cygwin
     Hello all.  I'm using postgresql 7.2 under cygwin.  And I have a
problem.

     I created a dump file, dropped the database, and created a new
database, and tried to reload the dump file.  It didn't work.  It gets so
far and stops, with:
CREATE
CREATE
\connect: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

     I create the database as user Administrator, and the dump the
reconnects as user treaves (from my unix boxes) to create the tables and
such.  I have tracked down the problem to the following lines in the dump
file that add support for plpgsql.  In this case, I'm not yet using
plpgsql, so it is not big deal, but this is a bug none the less, isn't it?
When I comment the three lines out (the connect & two create) the dump
loads fine.

 \connect - Administrator

--
-- TOC Entry ID 65 (OID 16787)
--
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: Administrator
--

 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE 'C';

--
-- TOC Entry ID 66 (OID 16788)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
--

 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
"plpgsql_call_handler" LANCOMPILER '';



pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: Native win32 Libpq
Next
From: "Tim Finch, FosterFinch Ltd"
Date:
Subject: Re: Can't reload dump