Is this a bug or is this how it is supposed to work? postgresql 7.3 (release) mac osx 10.2.2
select for update I have two terminal sessions open with psql running and talking to the same db. in window 1 : begin; in window 1 : select column1 from table where column1 = 'text' for update; in window 2 : update table set column1 = 'text 2' where column1 = 'text'; then nothing...(until I commit window 1 then window 2 just does the update) .. I expected an error or warning in window 2... sorry column/row locked for update... how can I trap for this. If client 1 is updating, client 2 needs to know, not just be stuck waiting. He/She has no idea why there is a delay. but then again, maybe I am using this wrong. Thanks, Ted __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
