Re: [PATCH] SQL assertions prototype

Jim Nasby <jim@nasby.net> wrote:

> This is another case where it would be very useful to restrict
> what relations a transaction (or in this case, a substransaction)
> can access. If we had the ability to make that restriction then
> we could force assertions that aren't plain SQL to explicitly
> specify what tables the assert is going to hit, and if the assert
> tries to do something different then we throw an error.
>
> The ability to restrict object access within a transaction would
> also benefit VACUUM and possibly the Changeset stuff.

I'm pretty sure that SSI could also optimize based on that,
although there are probably about 10 other optimizations that would
be bigger gains before getting to that.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company