Can't reload dump
От | TimothyReaves@westfieldgrp.com |
---|---|
Тема | Can't reload dump |
Дата | |
Msg-id | OFF2A9E682.661E8D0E-ON85256B7B.004FADA1@westfield-cos.com обсуждение исходный текст |
Ответы |
Re: Can't reload dump
|
Список | 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 по дате отправления: