Re: [GENERAL] delete commands fails silently to delete primary key

"Andrus" <[EMAIL PROTECTED]> writes: >> There have been a number of index-corruption bugs fixed since 8.1.4 ... >> >> In particular, if it's possible that any of these clients abort before >> committing these insertions, the vacuum race condition bug fixed in >> 8.1.10 is a pretty likely candidate

Re: [GENERAL] delete commands fails silently to delete primary key

There have been a number of index-corruption bugs fixed since 8.1.4 ... In particular, if it's possible that any of these clients abort before committing these insertions, the vacuum race condition bug fixed in 8.1.10 is a pretty likely candidate for your problem. I changed second statement to

Re: [GENERAL] delete commands fails silently to delete primary key

"Andrus" <[EMAIL PROTECTED]> writes: > I have table in 8.1.4 which tracks users logged into db There have been a number of index-corruption bugs fixed since 8.1.4 ... In particular, if it's possible that any of these clients abort before committing these insertions, the vacuum race condition bug

[GENERAL] delete commands fails silently to delete primary key

I have table in 8.1.4 which tracks users logged into db CREATE TABLE "session" ( workplace character(16) NOT NULL, ipaddress character(20), logintime character(28), loggeduser character(10), CONSTRAINT session_pkey PRIMARY KEY (workplace) ); Commands executed at logon in same transaction ar