Re: [PATCH] SQL assertions prototype - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PATCH] SQL assertions prototype
Date
Msg-id 52C9BD95.4010904@gmx.net
Whole thread Raw
In response to Re: [PATCH] SQL assertions prototype  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 12/18/13, 4:04 PM, Andrew Dunstan wrote:
> Umm, that's really a major limitation in utility. We need to come up
> with a better answer than this, which would essentially hobble the
> facility.

We don't have any facility to run a trigger on just any command, it
needs to be triggered by a table.  Of course, that's where your on
commit even triggers come in, presumably.  But for example, constraint
triggers support deferrability, which an on commit trigger wouldn't.
We'd just need DML triggers on any/no tables.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] SQL assertions prototype
Next
From: Peter Eisentraut
Date:
Subject: Re: more psprintf() use