On Friday 20 February 2009 7:57:32 pm decibel wrote:
On Feb 19, 2009, at 1:49 PM, Adrian Klaver wrote:
From the Oracle manual:
ENABLE NOVALIDATE means the constraint is checked for new or
modified rows, but existing data may violate the constraint.
So you are looking for an incomplete
On Feb 19, 2009, at 1:49 PM, Adrian Klaver wrote:
From the Oracle manual:
ENABLE NOVALIDATE means the constraint is checked for new or
modified rows, but existing data may violate the constraint.
So you are looking for an incomplete constraint?
More likely they want to add a constraint
Hi
In Oracle I can use the NOVALIDATE for constraints... like this
ALTER TABLE employee ADD
CONSTRAINT emp_ck
CHECK (married IN ('Y','N')) NO VALIDATE;
When the table is already populated this will be faster. Can you do the same in
Postgresql?
Thanks
Sharmila
--
Sent via
2009/2/19 SHARMILA JOTHIRAJAH sharmi...@yahoo.com:
Hi
In Oracle I can use the NOVALIDATE for constraints... like this
ALTER TABLE employee ADD
CONSTRAINT emp_ck
CHECK (married IN ('Y','N')) NO VALIDATE;
When the table is already populated this will be faster. Can you do the same
in
- SHARMILA JOTHIRAJAH sharmi...@yahoo.com wrote:
Hi
In Oracle I can use the NOVALIDATE for constraints... like this
ALTER TABLE employee ADD
CONSTRAINT emp_ck
CHECK (married IN ('Y','N')) NO VALIDATE;
When the table is already populated this will be faster. Can you do
the same in