dbTalk Databases Forums  

[BUGS] BUG #1944: Lock A row with the option NoWait

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1944: Lock A row with the option NoWait in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mathias Laurent
 
Posts: n/a

Default [BUGS] BUG #1944: Lock A row with the option NoWait - 10-06-2005 , 01:11 PM







The following bug has been logged online:

Bug reference: 1944
Logged by: Mathias Laurent
Email address: e1lauren (AT) hotmail (DOT) com
PostgreSQL version: 8.0
Operating system: windows
Description: Lock A row with the option NoWait
Details:

Hello,
I would like to know how to make a lock on a row with the instruction
NoWait. Because it is not possible with "Select .... For Update" which
don't
allow NoWait Behind !
Also if it is not possible to do this thing, could it be develloped in a
next version ?

thank you,

Mathias Laurent

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: [BUGS] BUG #1944: Lock A row with the option NoWait - 10-06-2005 , 01:21 PM






Mathias Laurent wrote:
Quote:
The following bug has been logged online:

Bug reference: 1944
Logged by: Mathias Laurent
Email address: e1lauren (AT) hotmail (DOT) com
PostgreSQL version: 8.0
Operating system: windows
Description: Lock A row with the option NoWait
Details:

Hello,
I would like to know how to make a lock on a row with the instruction
NoWait. Because it is not possible with "Select .... For Update" which
don't
allow NoWait Behind !
Also if it is not possible to do this thing, could it be develloped in a
next version ?
Yes, it will be in 8.1.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.