Re: [HACKERS] Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint

2006-06-07 Thread Kenneth Marshall
Travis, We have used postgresql 7.4, 8.0, and 8.1 with DSPAM and have never had a single problem like you are describing. In the past on this mailing list, these sorts of issues have been caused by hardware problems on the DB server in some cases. Good luck with tracking it down. Ken On Tue, Jun

Re: [HACKERS] Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint

2006-06-06 Thread Ian Barwick
On 6/6/06, Tom Lane <[EMAIL PROTECTED]> wrote: Travis Cross <[EMAIL PROTECTED]> writes: > I'm noticing that a handful (4-16) of rows with duplicate columns > (uid,token) are sneaking into the table every day despite the > primary key constraint. Corrupt index, looks like ... you might try reinde

Re: [HACKERS] Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint

2006-06-06 Thread Tom Lane
Travis Cross <[EMAIL PROTECTED]> writes: > I'm noticing that a handful (4-16) of rows with duplicate columns > (uid,token) are sneaking into the table every day despite the > primary key constraint. Corrupt index, looks like ... you might try reindexing the index. I don't believe that the PANIC y

[HACKERS] Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint

2006-06-06 Thread Travis Cross
I have a table that I am using to store email token data for DSPAM. I'm noticing that a handful (4-16) of rows with duplicate columns (uid,token) are sneaking into the table every day despite the primary key constraint. The server currently processes a few thousand emails per day, and this parti