pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dado Feigenblatt <dado@wildbrain.com>
To: pgsql-sql@postgresql.org
Subject: duplicated OIDs ?
Date: Tue, 10 Jul 2001 10:55:28 -0700
Message-ID: <3B4B4190.2C70F618@wildbrain.com> (raw)

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.






Message-ID: <3B4B4190.2C70F618@wildbrain.com>
Permalink:  ../3B4B4190.2C70F618@wildbrain.com/
Also on:    postgresql.org/message-id/3B4B4190.2C70F618@wildbrain.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dado@wildbrain.com
  Subject: Re: duplicated OIDs ?
  In-Reply-To: <3B4B4190.2C70F618@wildbrain.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox