In general I need to lock whole table so only one session can
perform update. I'm looking for solution that will work in both C++
Will 'SELECT FOR UPDATE' lock whole table?
As per 'LOCK' will lock released if connection get closed abnormally?
( example: hard crash on the client side, network interruptions,
etc.) Can LOCK be used in JDBC or it's SQL92 standard?
Thanks a lot.
--- Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> On Thu, Dec 23, 2004 at 11:56:26AM -0800, Mark wrote:
> > Is it possible to lock row(s) when updating a table, so another
> > for update( from different session) will be rejected and to be on
> > hold until lock get released ?
> The UPDATE statement automatically acquires locks, but if you need
> more control then you could use SELECT FOR UPDATE or LOCK. For
> more information see the "Concurrency Control" chapter in the
> What problem are you trying to solve? Depending on what you're
> doing, you might not need to use explicit locking.
> Michael Fuhr
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
In response to
pgsql-general by date
|Next:||From: girgen||Date: 2004-12-29 15:18:03|
|Subject: using pg_config to get LDFLAGS?|
|Previous:||From: Edgars Diebelis||Date: 2004-12-29 08:59:01|
|Subject: Re: 8.0 Beta3 worked, RC1 didn't!|