Thread: [ psqlodbc-Bugs-1000496 ] FOR UPDATE NOWAIT returns no error in case of locking
Bugs item #1000496, was opened at 2005-12-21 10:17 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000496&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Nobody (None) Assigned to: Nobody (None) Summary: FOR UPDATE NOWAIT returns no error in case of locking Initial Comment: When sending the SELECT FOR UPDATE NOWAIT; Statement, the driver returns with no errorcode regardless if the rows are lockedby another transaction or not. Doing this in pgAdmin/SQL Tool the server reports in case of locking this error text: ERROR: could not obtain lock on row in relation "XXX" Im using PostgreSQL ANSI Driver for Windows 8.01.01.05 Date 18.12.05 PostgreSQL Server 8.1.1 for Windows ---------------------------------------------------------------------- >Comment By: Dave Page (dpage) Date: 2006-04-28 09:00 Message: Please test version 08.02.0002 (available from http://pgfoundry.org/frs/?group_id=1000125) and report whether or not theproblem still exists. ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000496&group_id=1000125