On Thu, Nov 4, 2010 at 11:03 AM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > Is there a way to require that a check constraint be checked on insert but > not update? Worth knowing is that my check constraint runs a PLPgsql proc > which returns a yes/no kinf of flag which the constraint proper checks. Use an explicit ON INSERT trigger that calls your procedure instead of a check constraint. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general