----- "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 Postgresql?
> Thanks
> Sharmila

>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?

Adrian Klaver
akla...@comcast.net
> 
> 
>       
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to