[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 !

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 dave.gauth...@intel.com 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

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 dave.gauth...@intel.com 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