Re: [GENERAL] check constraint on insert but not delete

2010-11-04 Thread Richard Broersma
On Thu, Nov 4, 2010 at 8:03 AM, Gauthier, Dave 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. I think by de

Re: [GENERAL] check constraint on insert but not delete

2010-11-04 Thread Vick Khera
On Thu, Nov 4, 2010 at 11:03 AM, Gauthier, Dave 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 expl

[GENERAL] check constraint on insert but not delete

2010-11-04 Thread Gauthier, Dave
This is a longshot, but here goes... 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. Thanks !