Postgres Pro
Downloads
Home   >   mailing lists

Question about check constraints - Mailing list pgsql-sql

From Kashmira Patel \(kupatel\)
Subject Question about check constraints
Date
Msg-id 18AE59788A3FC640A367E5652E664D8001730F33@xmb-sjc-237.amer.cisco.com
Whole thread Raw
List pgsql-sql
Tree view
Hi all,
  I have a table where two columns have two different check constraints associated with them. When I update one column, the check constraint on the other column is also executed. Is there a way to avoid this? I want to check only for the condition defined for the column being updated.
 
Thanks,
Kashmira

pgsql-sql by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: [GENERAL] hi all......................!!
Next
From: Joe Abbate
Date:
Subject: UPDATE with correlated aggregates