assertions and constraint triggers - Mailing list pgsql-hackers

From Peter Eisentraut
Subject assertions and constraint triggers
Date
Msg-id 1281504702.9631.2.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: assertions and constraint triggers  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Re: assertions and constraint triggers  (Simon Riggs <simon@2ndQuadrant.com>)
Re: assertions and constraint triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thinking about SQL assertions (check constraints that are independent of
one particular table), do you think it would be reasonable to implement
those on top of constraint triggers?  On creation you'd hook up a
trigger to each of the affected tables.  And the trigger function runs
the respective check expression.  Conceptually, this doesn't seem to be
very far away from foreign key constraints after all.



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: RecordTransactionCommit() and SharedInvalidationMessages
Next
From: Greg Stark
Date:
Subject: Re: string_to_array with an empty input string