Received: from wonder.kss.net.au ([203.41.122.41]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBE7U3m37941 for ; Fri, 14 Dec 2001 02:30:04 -0500 (EST) (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 SAA25587 for ; Fri, 14 Dec 2001 18:45:15 +1100 Message-ID: <3C19AA4E.CF8D4C10@greatpacific.com.au> Date: Fri, 14 Dec 2001 18:29:18 +1100 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: weird duplicate data problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/140 X-Sequence-Number: 5963 a table was created with: create table bills ( id serial not null, account_no int4 not null, date_issued date not null, ..... ); The following SQL script returns only 1 row of data: select oid, * from bills where id = xxxxx' order by oid; However with the following SQL: select oid, * from bills where date_issued = '01/01/2001' order by oid; some of the data is duplicated, including the OID. When trying to 'vaccum' the database, get NOTICE: Index bills_id_key: number of index tupples (4755) is not the same as heap (7800). What is happening? What could have caused this? Database version used is V6.50. I know it's old, but i hope it's not the version that's causing this problem. Thanks in advance for any suggestions.