Re: [GENERAL] 8.1.2 select for update issue

2007-08-06 Thread Ed L.
On Monday 06 August 2007 2:11 pm, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > On Monday 06 August 2007 1:22 pm, you wrote: > >> You really ought to be using something newer than 8.1.2. > > > > Perhaps. But we have yet to find a way to make major > > version upgrades of 100+ GB, > > I

Re: [GENERAL] 8.1.2 select for update issue

2007-08-06 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > On Monday 06 August 2007 1:22 pm, you wrote: >> You really ought to be using something newer than 8.1.2. > Perhaps. But we have yet to find a way to make major version > upgrades of 100+ GB, I did not suggest a major version upgrade.

Re: [GENERAL] 8.1.2 select for update issue

2007-08-06 Thread Ed L.
On Monday 06 August 2007 1:22 pm, you wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > We're seeing some unexpected behavior in one particular > > 64-bit Pgsql 8.1.2 running on HP-UX 11.23 and Itanium 2, > > built with --enable-thread-safety. We think we are seeing > > concurrent select-for-update

Re: [GENERAL] 8.1.2 select for update issue

2007-08-06 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > We're seeing some unexpected behavior in one particular 64-bit > Pgsql 8.1.2 running on HP-UX 11.23 and Itanium 2, built > with --enable-thread-safety. We think we are seeing concurrent > select-for-updates of the same rows by multiple concurrent > backend