Re: Constraint documentation

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