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

From Dean Rasheed
Subject Re: WIP: Deferrable unique constraints
Date
Msg-id 8e2dbb700907271203x13896fe8g2da7ed936231dcc9@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Deferrable unique constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/7/27 Tom Lane <tgl@sss.pgh.pa.us>:
> (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