Re: multi-row check constraints? - Mailing list pgsql-general

From Jeff Davis
Subject Re: multi-row check constraints?
Date
Msg-id 1174669387.23455.615.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: multi-row check constraints?  ("Martin Gainty" <mgainty@hotmail.com>)
List pgsql-general
On Thu, 2007-03-22 at 20:48 -0400, Martin Gainty wrote:
> Greetings
>
> Select COLUMN FROM TABLE WHERE (some condition) for UPDATE OF COLUMN
> is not supported?
>

Yes, it is supported.

> what would happen in a Table Deadlock scenario???

The deadlock detector detects the deadlock, causing one transaction to
be aborted with an error.

What kind of deadlock scenario are you concerned about?

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Vladimir Zelinski
Date:
Subject: Re: question: knopixx and postgresql on flash drive
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: shell script to SQL statement: `pg_dump | psql -U`