Received: from f1node03.rhrz.uni-bonn.de (node03.rhrz.uni-bonn.de [131.220.18.133]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4S9UKA23039 for ; Mon, 28 May 2001 05:30:22 -0400 (EDT) (envelope-from jtr@uni-bonn.de) Received: from wabe.germanistik.uni-bonn.de (ascend-tk-p198.dialin.uni-bonn.de [131.220.244.198]) by f1node03.rhrz.uni-bonn.de (8.9.3/8.9.3) with ESMTP id LAA277070; Mon, 28 May 2001 11:30:14 +0200 Received: by wabe.germanistik.uni-bonn.de (Postfix, from userid 1000) id EAD35AF9B5; Mon, 28 May 2001 11:28:40 +0200 (CEST) To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Problems with pg_dump (on Debian i386) References: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de> <5080.990800971@sss.pgh.pa.us> From: Joachim Trinkwitz Date: 28 May 2001 11:28:40 +0200 In-Reply-To: <5080.990800971@sss.pgh.pa.us> Message-ID: <878zjhstyv.fsf@wabe.germanistik.uni-bonn.de> Lines: 18 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Copyleft) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" X-Archive-Number: 200105/288 X-Sequence-Number: 3116 --=-=-= Tom Lane writes: > Could we see a specific example please --- preferably, enough of the > dump file to reproduce the problem? Also, exactly *what* version hop > are we talking about? Example file (extract of my dump file) is attached -- the misbehaviour occurs even when simply \i-ing this file in psql. Regarding version hops: I've followed Oliver Elphicks Debian (unstable) releases except the RC test releases and now I'm at 7.1.1. Not sure when this occured, but with 6.xx it worked for sure. Greetings and thanks for your help, joachim --=-=-= Content-Type: application/octet-stream Content-Disposition: attachment; filename=germdb.sql Content-Description: Example file for psql misbehaviour CREATE TABLE "lplan" ( "semester" character(6) NOT NULL, "art" character[] NOT NULL, "lplnr" integer DEFAULT nextval('lplan_lplnr_seq'::text) NOT NULL, "nachname" character varying(50), "vorname" character varying(50), "veranst_titel" character varying(150), "daf" boolean DEFAULT 'f', "tag" character(2), "uhrzeit" character varying(100), "ort" character varying(100), "dozent" smallint, "lastchanged" timestamp with time zone DEFAULT 'now', "kvvnr" character(4), "medien" boolean DEFAULT 'f', Constraint "lplan_pkey" Primary Key ("semester", "lplnr") ); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"7"}',1,'Trinkwitz','Joachim','Computer- und Internetnutzung f\374r Germanisten','f','Fr','11-13','CIP-Pool',80,'12.01.2001 10:16:03.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.4"}',204,'St\344hler','Axel','Jerusalem - in Geschichte und Literatur','f','Mi','16-18','\334R 4, VZ',111,'01.02.2001 11:22:07.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"1.4"}',3,'Kemper','Tobias A.','Einf\374hrung ins Mittelhochdeutsche','f','Mo','14-16','VZ',95,'12.01.2001 11:05:46.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',25,'Kraft','Stephan','Kom\366die','t','Mo','14-16','gro\337er \334bungsraum',37,'17.01.2001 14:43:49.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.2"}',5,'Niewerth','Heinz-Peter','','f','Di','09-11','\334 6 im VZ',51,'14.01.2001 17:10:08.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.2"}',6,'Niewerth','Heinz-Peter','','f','Di','11-13','\334 6 im VZ',51,'14.01.2001 17:11:18.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',7,'Niewerth','Heinz-Peter','','t','Mi','09-11','\334 5',51,'14.01.2001 17:12:26.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"1.3"}',41,'M\366ller','Robert','Einf\374hrung in die historische Sprachbetrachtung','f','Fr','11-13','IGL, Am Hofgarten 22',47,'24.01.2001 15:06:06.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.4"}',9,'Niewerth','Heinz-Peter','','f','Do','14-16','\334 5',51,'14.01.2001 17:15:44.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.8"}',10,'Niewerth','Heinz-Peter','','f','Do','11-13','\334 1',51,'14.01.2001 17:16:28.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',11,'Niewerth','Heinz-Peter','','t','Mi','11-13','AR V, 2. OG',51,'14.01.2001 17:17:42.00 CET'); INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.1"}',12,'Oellers','Norbert','Schiller 2','t','Mi','10-11','HS VIII',55,'15.01.2001 10:54:37.00 CET'); --=-=-=--