From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | sharmi jo <sharmi_jo(at)yahoo(dot)com> |
Cc: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: NOVALIDATE in postgresql? |
Date: | 2009-02-19 19:49:46 |
Message-ID: | 1473059680.167281235072986604.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- "SHARMILA JOTHIRAJAH" <sharmi_jo(at)yahoo(dot)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
aklaver(at)comcast(dot)net
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Featherlight | 2009-02-19 20:13:44 | Re: Service not starting during install |
Previous Message | Osvaldo Kussama | 2009-02-19 19:43:45 | Re: NOVALIDATE in postgresql? |