On 25/06/18 17:45, Lætitia Avrot wrote:
> + <note>
> + <para>
> + Check constraint are not designed to enforce business rules across tables.
> + Avoid using check constraints with function accessing other tables and
"with functions" or "with a function". I prefer the former.
> + use <xref linkend="triggers"/> instead. Although PostgreSQL won't prevent you
> + from doing so, but beware that dumps generated by <application>pg_dump</application>
No but.
> + or <application>pg_dumpall</application> may be hard
> + to restore because of such checks, as the underlying dependencies are not
> + taken into account.
> + </para>
> + </note>
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support