On 2017-11-06 06:50, dmigowski@ikoffice.de wrote:
> The is no way to VALIDATE constraints that PostgreSQL already thinks of as
> VALID. I would love a "force" option here, because when disabling all
> triggers there is still the possibility for errors and I would love to check
> our databases for them.
>
> How do I do it?
This is a feature request, but I need it too.
My work-around is to use a DO statement that iterates over pg_constraint
to duplicate all interesting constraints giving each a new name and ends
with a RAISE EXCEPTION 'OK'. If the execution ends with that "error",
all constraints are valid. I guess you could wrap it into a BEGIN ...
ROLLBACK to get the same effect.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs