| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Create Assertion -- Question from a newbie |
| Date: | 2006-08-28 14:27:31 |
| Message-ID: | 20060828142731.GF27526@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Andrew Sullivan wrote:
> On Sun, Aug 27, 2006 at 07:39:49AM -0700, Richard Broersma Jr wrote:
>
> > Ah, I see. So the points is that checking the integrity between
> > two complete data sets can become a preformace killer.
>
> Not necessarily. More exactly, building a support system that can
> check such integrity in a completely general way, such that it could
> be used for any arbitrary data, is a hard problem that might destroy
> performance. It's also a pretty exotic feature. You might want to
> ask on the -hackers list for more detail, though.
Well, it's on the SQL standard, so we should look forward to
implementing (some form of) it some day.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sumeet | 2006-08-28 14:29:20 | Temporary Views or tables |
| Previous Message | Henry Ortega | 2006-08-28 14:02:32 | Trigger on Insert to Update only newly inserted fields? |