Re: [BUGS] BUG #1242: Major bug in pgSQL

2004-09-10 Thread Nobody
Thank you very much for a quick answer. Here is our situation: Query: select cmax, cmin, xmax, xmin, ctid, oid, * from unitcontainer where unitcontainername = 'Track'; Result: oid id_unitcontainerid_basecomb id_unitcontainertype id_userinstance unitcontainername 16.995

Re: [BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > When you are experiencing this show us the result of this query: > select cmax, cmin, xmax, xmin, * from where ; Also, please, the ctid and oid columns (but leave out oid if you made the table WITHOUT OIDS). Also, if the condition is one that will no

Re: [BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread Gaetano Mendola
PostgreSQL Bugs List wrote: Problem: in some cases we experience the following problem - we have found in the database some _absolutely_ identical rows, despite the fact, that we have defined some unique (!) indexes on some of the fields and even primary (!) keys, we can see, that the rows are