Re: WIP: Deferrable unique constraints - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: WIP: Deferrable unique constraints
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: WIP: Deferrable unique constraints  (Tom Lane <[email protected]>)
List pgsql-hackers
2009/7/27 Tom Lane <[email protected]>:
> (In fact, in a real sense these ARE join problems ... maybe we should
> stop thinking of them as fire-a-bunch-of-triggers and instead think of
> executing a single check query with appropriate WHERE clause ...)
>

Hmm. Presumably that is the same WHERE clause as the UPDATE.
But it has to execute after the update. How does it avoid re-executing
functions, re-incrementing sequences, etc... ?
- Dean


pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: WIP: Deferrable unique constraints
Next
From: Zach Conrad
Date:
Subject: potential bug with query optimizer and functions