psql won't accept pg_dump
От | Michael Hipp |
---|---|
Тема | psql won't accept pg_dump |
Дата | |
Msg-id | 418FC8DD.5080102@Hipp.com обсуждение исходный текст |
Ответы |
Re: psql won't accept pg_dump
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: