Received: from flip.wildbrain.com ([206.54.55.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6AHvZa22467 for ; Tue, 10 Jul 2001 13:57:36 -0400 (EDT) (envelope-from dado@wildbrain.com) Received: from wildbrain.com (daedelus.wildbrain.com [192.168.1.38]) by flip.wildbrain.com (8.9.3/8.9.3) with ESMTP id JAA07637 for ; Tue, 10 Jul 2001 09:55:29 -0700 Message-ID: <3B4B4190.2C70F618@wildbrain.com> Date: Tue, 10 Jul 2001 10:55:28 -0700 From: Dado Feigenblatt X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2smp i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: duplicated OIDs ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/110 X-Sequence-Number: 3895 I have this test DB (thank's God!) where I was fooling around. I was playing with data from a pg_dump (tables and data with OID's). The generated SQL script doesn't check for the existence of the DB, and doesn't use transactions. So it failed on creating the DB, but copied the dumped data in again, with OIDs. So now I have duplicated records with *duplicated OIDs* !!! I thought that would *never* happen, even with COPY table WITH OIDS FROM stdin; PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96 -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415) 553-8000 x??? dado@wildbrain.com San Francisco, CA.