You can use the statement timeout GUC parameter to time out the second
one. However in general holding a lock in a gui
is a bad idea if you are holding it for any length of time. You may
want to re-think your locking strategy.
Mican Bican wrote:
>I use Postgresql 8.0.1 with java 5 and jdbc3 on windows xp.
>When I do a "select for update" a row.. and dont commit the statement
>and when in this time an other user do also this. my java gui wait and
>locked till the first user commit his statement.. my question is how
>can I realize this with java.. for example why they are not a
>SQLException or are Error like "an other user is updating this row"...
>or can I say to java "dont wait" or "dont lock" when you make a select
>for update and an other user before you make this..
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
519 939 0336
In response to
pgsql-jdbc by date
|Next:||From: Csaba Nagy||Date: 2005-03-09 16:44:32|
|Subject: Re: [JDBC] java is locked when select for update|
|Previous:||From: Csaba Nagy||Date: 2005-03-09 16:12:40|
|Subject: Re: java is locked when select for update|
pgsql-general by date
|Next:||From: FERREIRA William (COFRAMI)||Date: 2005-03-09 16:31:01|
|Previous:||From: Geoffrey||Date: 2005-03-09 16:28:05|
|Subject: Re: PostgreSQL still for Linux only?|