+1

interesting feature

Pavel


2013/11/15 Peter Eisentraut <pete...@gmx.net>

> Various places in the constraint checking code say something like, if we
> ever implement assertions, here is where it should go.  I've been
> fiddling with filling in those gaps for some time now, and the other day
> I noticed, hey, this actually kind of works, so here it is.  Let's see
> whether this architecture is sound.
>
> A constraint trigger performs the actual checking.  For the
> implementation of the trigger, I've used some SPI hacking for now; that
> could probably be refined.  The attached patch has documentation, tests,
> psql support.  Missing pieces are pg_dump support, dependency
> management, and permission checking (the latter marked in the code).
>
> This is not a performance feature.  It's for things like, this table
> should have at most 10 rows, or all the values in this table must be
> bigger than all the values in that other table.  It's a bit esoteric,
> but it comes up again and again.
>
> Let me know what you think.
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>

Reply via email to