Re: Select For Update question

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Select For Update question
Date: 2003-03-26 08:05:43
Message-ID: 3E815F57.8070208@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Barry Lind wrote:
>
> You should check out the Javadoc for the Connection object

Thanks for pointing me in the right direction. I've read the relevant
docs and was able to write up a quick test program that does properly
lock the rows when "select .. for update" is used.

I know this is not specifically postgres related, but if my application
crashes after putting a lock on some rows, I have notice that postgres
releases the locks.

Is the behaviour reliable? I.e. can feel safe in that if my application
crashes any locks it held will be released?

Thanks,

Jean-Christian Imbeault

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-03-26 16:40:16 Re: Select For Update question
Previous Message Shanmugasundaram Doraisamy 2003-03-26 08:01:24 Help Needed with Connection Pooling for Java Swing Based applications - reg.