Re: Constraints & pg_dump

Tom Lane wrote:

>Our present handling of CHECK constraints cannot reasonably be
>thought to support anything but row-local constraints.  If they're using
>a function to make an end-run around the check that prohibits subselects
>in CHECK constraints, then their problems are much more serious than
>whether pg_dump dumps the database in an order that manages to avoid
>failure.  That kind of constraint just plain does not work, because it
>won't get rechecked when the implicitly referenced rows change.
>  
>

Ouch. Two days ago I saw someone on IRC (I think from this list) 
actually advising someone to use this end-run. Maybe we need to beef up 
the docs on this point?

cheers

andrew