Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Assertion -- Question from a newbie - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Create Assertion -- Question from a newbie
Date
Msg-id 20060827143949.16261.qmail@web31812.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Create Assertion -- Question from a newbie  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Create Assertion -- Question from a newbie  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
Tree view 
> You can accomplish what assertions do using triggers.
> I think the issue is generating triggers for general assertions that don't
> totally suck performancewise.

Ah, I see.  So the points is that checking the integrity between two complete data sets can become
a preformace killer.

Thanks for the feed back.

Regards,

Richard Broersma Jr.

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Create Assertion -- Question from a newbie
Next
From: "Aaron Bono"
Date:
Subject: Re: Performance Problem with sub-select using array