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

[BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1242 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Linux Debian 3.1 Description:Major bug in pgSQL Details: Hi, apparently we have found a critical bug in pgSQL