X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9ECB1D1B1B0 for ; Tue, 13 Jul 2004 14:54:57 -0300 (ADT) 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 71248-06 for ; Tue, 13 Jul 2004 17:54:57 +0000 (GMT) Received: from fe09.axelero.hu (fe09.axelero.hu [195.228.240.97]) by svr1.postgresql.org (Postfix) with ESMTP id A797ED1B1A5 for ; Tue, 13 Jul 2004 14:54:54 -0300 (ADT) Received: from fe09 (localhost-02 [127.0.2.1]) by fe09.axelero.hu (8.12.11/8.12.11) with SMTP id i6DHssmm036820 for ; Tue, 13 Jul 2004 19:54:55 +0200 (CEST) Received: from fe09.axelero.hu [127.0.2.1] via SMTP gateway by fe09 [195.228.240.97]; id A08FCDC5D41 at Tue, 13 Jul 2004 19:54:53 +0200 Received: from fejleszt4 (121-248-182-81.adsl-fixip.axelero.hu [81.182.248.121]) by fe09.axelero.hu (8.12.11/8.12.11) with SMTP id i6DHsrXD036800 for ; Tue, 13 Jul 2004 19:54:53 +0200 (CEST) Message-ID: <023401c46902$71e1a1c0$0403a8c0@fejleszt4> From: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" To: Subject: Certain COPY's ignored from dump? Date: Tue, 13 Jul 2004 19:54:28 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-RAVMilter-Version: 8.4.3(snapshot 20030217) (fe09.axelero.hu) 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: 200407/83 X-Sequence-Number: 18335 Dear Gurus, Dumping from 7.3 to 7.4 seems to omit some of the COPY commands, without any warning or error. The table is created, there are notices about indexes in the log, but COPY doesn't seem to happen-- the table remains empty at the end of the dump. As far as we discovered, these are a couple of tables with <10 rows. Not sure, but it's very likely that until recently this problem didn't show up, and that makes me suspect a database or configuration change that may be behind it, tho I'm quite sure we didn't mess with 7.4's config for quite a long time. Any ideas? Checked in "Migration to version 7.4", but none of that seems to apply. TIA, G. %----------------------- cut here -----------------------% \end