Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2REdNw03711 for ; Tue, 27 Mar 2001 09:39:23 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2R9ADw59800; Tue, 27 Mar 2001 04:10:13 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f2R92j576764; Tue, 27 Mar 2001 04:02:45 -0500 (EST) (envelope-from news) From: Marcin Kowalski X-Newsgroups: comp.databases.postgresql.admin, comp.databases.postgresql.bugs, comp.databases.postgresql.general Subject: pg_dump potential bug Followup-To: comp.databases.postgresql.admin Date: Tue, 27 Mar 2001 11:03:07 +0200 Organization: Datrix Solutions Lines: 36 Message-ID: <99pkvj$2are$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-admin@postgresql.org.pgsql-bugs@postgresql.org.pgsql-general@postgresql.org X-Archive-Number: 200103/194 X-Sequence-Number: 1041 Hi All... I've got a slight problem with pg_dump in Postgres v7.0.3, in basically duplicates all the data that it extracts I do a testdatabase>CREATE TABLE bob (number int4,description text); testdatabase>INSERT INTO TABLE bob VALUES (4453,'This is just a test of pg_dump'); then kowalski@dagoba > pg_dump -t bob testdatabase \connect - kowalski CREATE TABLE "bob" ( "number" int4, "description" text ); CREATE TABLE "bob" ( "number" int4, "description" text ); COPY "bob" FROM stdin; 4453 This is just a test of pg_dump \. COPY "bob" FROM stdin; 4453 This is just a test of pg_dump \. As you can see the records are duplicated. I discovered this when I tried to migrate from 7.0.3 to 7.1 and found performance suddenly took a terrible dive. Is there a patch for pg_dump ?? Thanks for any help MarCin