NOVALIDATE in postgresql?

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: NOVALIDATE in postgresql?
Date: 2009-02-19 19:37:23
Message-ID: 3929.4338.qm@web110709.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2009-02-19 19:43:45 Re: NOVALIDATE in postgresql?
Previous Message SHARMILA JOTHIRAJAH 2009-02-19 19:07:46 Re: How to pipe the psql copy command to Unix 'Date' command