From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Jim Nasby <jim(at)nasby(dot)net>, Joshua D(dot) Drake <jd(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID |
Date: | 2011-11-11 03:32:33 |
Message-ID: | 1320982284-sup-1138@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Excerpts from Thom Brown's message of jue nov 10 21:28:06 -0300 2011:
>
> On 10 November 2011 23:56, Thom Brown <thom(at)linux(dot)com> wrote:
> > The dump correctly contains:
> >
> > CREATE TABLE a (
> > num integer,
> > CONSTRAINT meow CHECK ((num < 20)) NOT VALID
> > );
>
> Actually I mean incorrectly contains, because the constraint needs
> adding after the data insertion, not as part of the create table
> statement.
Interesting, thanks -- I'll look into it.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | User Hinoue | 2011-11-11 12:11:31 | psqlodbc - psqlodbc: Adjust the operations after closing eof-detected |
Previous Message | Thom Brown | 2011-11-11 00:28:06 | Re: [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-11-11 03:41:13 | Re: type privileges and default privileges |
Previous Message | Stephen Frost | 2011-11-11 03:29:12 | Re: type privileges and default privileges |