Received: from wonder.kss.net.au ([203.41.122.41]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f86Nus788252 for ; Thu, 6 Sep 2001 19:56:55 -0400 (EDT) (envelope-from carolyn@greatpacific.com.au) Received: from greatpacific.com.au (coco [10.10.1.9]) by wonder.kss.net.au (8.9.3/8.8.7) with ESMTP id JAA27672 for ; Fri, 7 Sep 2001 09:53:28 +1000 Message-ID: <3B980C81.365226FF@greatpacific.com.au> Date: Fri, 07 Sep 2001 09:53:37 +1000 From: Carolyn Lu Wong Organization: Great Pacific Financial Group X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: duplicated oid References: <3B930A0A.64EC6D82@greatpacific.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200109/22 X-Sequence-Number: 4668 anyone knows if duplicated oid is possible?? is there a possible way to remove the duplicate row, now that i don't know which ID to use? any suggestions? Carolyn Lu Wong wrote: > > i'm using V6.5. > > >From my understanding, the oid should be unique in all rows of database. > However, I'm getting duplicated data on one particular table, including > the oid is the same! I don't recall trying to restore nor import any > data. > > Any idea why? > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org