Re: SELECT statements converted to SELECT FOR UPDATE

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Richard Mischook <rmischook(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT statements converted to SELECT FOR UPDATE
Date: 2002-10-23 18:37:43
Message-ID: 20021023113726.X7340-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22 Oct 2002, Richard Mischook wrote:

> We've got some deadlock issues that we're trying to solve. In looking
> at the logs we note a bunch of statements that were written as SELECT
> being listed by PG as SELECT FOR UPDATE. Was wondering what leads to
> that (foreign keys, transactions). We are using JDBC and are not tried
> setting the transaction isolation level of the connection.

Probably foreign keys as they use SELECT FOR UPDATE to handle the locking.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-10-23 18:43:37 Re: Rollback deletes
Previous Message Oleg Lebedev 2002-10-23 18:36:52 Rollback deletes