Can't reload dump

From: TimothyReaves(at)westfieldgrp(dot)com
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Can't reload dump
Date: 2002-03-13 14:37:05
Message-ID: OFF2A9E682.661E8D0E-ON85256B7B.004FADA1@westfield-cos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 '';

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Tim Finch, FosterFinch Ltd 2002-03-14 12:06:37 Re: Can't reload dump
Previous Message Jason Tishler 2002-03-13 12:41:55 Re: Native win32 Libpq