Re: multi-row check constraints?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Martin Gainty <mgainty(at)hotmail(dot)com>
Cc: Angva <angvaw(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: multi-row check constraints?
Date: 2007-03-23 17:03:07
Message-ID: 1174669387.23455.615.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter 2007-03-23 17:30:17 Async triggers
Previous Message James Neff 2007-03-23 15:12:25 Re: question: knopixx and postgresql on flash drive