Re: [BUGS] Transaction isolation with concurrent increments

2002-06-04 Thread Tom Lane
Nico Erichsen <[EMAIL PROTECTED]> writes: > set transaction isolation level serializable; > begin; > update counters set counter1=(select counter1+1 from counters); Try it the other way round: begin; set transaction isolation level serializable; update c

[BUGS] Transaction isolation with concurrent increments

2002-06-04 Thread Nico Erichsen
Well, I'm a relative newbie to SQL, but I have been told that this behaviour is a bug. I hope I didn't misunderstand something. To reproduce, first create a table 'counters' that looks like that: counter1 -- 0 (1 row) Then execute the following commands parallelly on two psq

Re: [BUGS] PQescapeString and PQescapeBytea not exported during win 32 build

2002-06-04 Thread Rob Butler
I applied the patch, and recompiled postgres, then recompiled my program using the PQescapeString function. My program can now compile fine, but any attempt to run it results in the following error message. "the ordinal 88 could not be located in the Dynamic Link Library libpq.dll" Rob >Fr