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