X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F22C73A4079 for ; Mon, 8 Nov 2004 19:27:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95932-08 for ; Mon, 8 Nov 2004 19:27:33 +0000 (GMT) Received: from ws6-4.us4.outblaze.com (ws6-4.us4.outblaze.com [205.158.62.107]) by svr1.postgresql.org (Postfix) with SMTP id 6F4BB3A3E98 for ; Mon, 8 Nov 2004 19:27:33 +0000 (GMT) Received: (qmail 2259 invoked from network); 8 Nov 2004 19:27:32 -0000 Received: from unknown (HELO ?192.168.0.204?) (michael@hipp.com@69.152.47.198) by ws6-4.us4.outblaze.com with SMTP; 8 Nov 2004 19:27:32 -0000 Message-ID: <418FC8DD.5080102@Hipp.com> Date: Mon, 08 Nov 2004 13:28:29 -0600 From: Michael Hipp User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: psql won't accept pg_dump Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/61 X-Sequence-Number: 15446 Here's what I do: pg_dump testdb > test.psql dropdb testdb createdb testdb psql -f test.psql testdb But there are 2 things where it won't accept it's own output as input. ######### CASE #1 psql:test.psql:18: ERROR: unrecognized configuration parameter "default_with_oids" ######### CASE #2 psql:test.psql:42: ERROR: invalid input syntax for type timestamp: "2004-10-30 21:11:00 501 so3 Test Sat morning CMH 2004-10-30 11:11:43.25 michael unknown" CONTEXT: COPY dailylog, line 1, column enttime: "2004-10-30 21:11:00 501 so3 Test Sat morning CMH 2004-10-30 11:11:43.25 michael unknown" (Note that if I change the 21:11:00 to 11:11:00 it works fine. It appears to be only wanting input in 12-hour format.) ######### Snippets from the test.psql file: SET default_with_oids = true; CREATE TABLE dailylog ( enttime timestamp without time zone, unit_calling character varying(8), unit_called character varying(8), info character varying(500), oper character varying(4), sys_time timestamp without time zone, station character varying(32), stauser character varying(32) ); COPY dailylog (enttime, unit_calling, unit_called, info, oper, sys_time, station, stauser) FROM stdin; 2004-10-30 21:11:00 501 so3 Test Sat morning CMH 2004-10-30 11:11:43.25 michael unknown This is POstgreSQL 7.4.5 on Cygwin. Any help? Thank you, Michael Hipp Hipp & Associates