Re: [BUGS] BUG #1074: postgresql crashes

2004-05-08 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The database cores with the following message printed on screen. > WARNING: specified item offset is too large Hmm. AFAICS this should always be followed by an ERROR message. There are at least two issues here: why does this message occur, an

Re: [BUGS] unique index problems

2004-05-08 Thread Tom Lane
Some time back, Costin Grigoras <[EMAIL PROTECTED]> wrote: > how could duplicate records appear when the unique index existed ? After re-reading this old bug report, I realized that all of the methods you were applying would make use of the index itself to search for duplicates --- the count(*) su