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

From Andrew Dunstan
Subject Re: [PATCH] SQL assertions prototype
Date
Msg-id 52B1AB28.20002@dunslane.net
Whole thread Raw
In response to Re: [PATCH] SQL assertions prototype  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On 12/18/2013 06:00 AM, Heikki Linnakangas wrote:
>
>
> If you don't force everything to run in SSI mode, then you have to 
> somehow figure out what parts do need to run in SSI mode to enforce 
> the assertion. For example, if the assertion refers tables A and B, 
> perhaps you can get away without predicate locks on table C?
>
>


But the assertion might simply run a function. For non-trivial cases 
that's what I would expect people to do.

cheers

andrew




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters
Next
From: Stephen Frost
Date:
Subject: Re: SQL objects UNITs (was: Extension Templates S03E11)