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

From Peter Eisentraut
Subject Re: [PATCH] SQL assertions prototype
Date
Msg-id 52C9BC92.4020901@gmx.net
Whole thread Raw
In response to Re: [PATCH] SQL assertions prototype  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 12/18/13, 2:45 PM, Andres Freund wrote:
> Well, the patch's syntax seems to only allow to directly specify a SQL
> query to check - we could iterate over the querytree to gather all
> related tables and reject any function we do not understand.

Creating an assertion scans the query tree and attaches constraint
triggers to all tables covered by the assertion condition.  So it does
essentially work the way you say.





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] SQL assertions prototype
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] SQL assertions prototype