Excerpts from Thom Brown's message of mar may 31 20:18:18 -0400 2011: > On 31 May 2011 18:43, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > > > > Here it is -- as a context patch this time, as well.
> There is this scenario: > > test=# CREATE DOMAIN things AS INT CHECK (VALUE > 5); > CREATE DOMAIN > test=# CREATE TABLE abc (id SERIAL, stuff things); > NOTICE: CREATE TABLE will create implicit sequence "abc_id_seq" for > serial column "abc.id" > CREATE TABLE > test=# INSERT INTO abc (stuff) VALUES (55); > INSERT 0 1 > test=# ALTER DOMAIN things ADD CONSTRAINT meow CHECK (VALUE < 11) NOT VALID; > ERROR: column "stuff" of table "abc" contains values that violate the > new constraint > STATEMENT: ALTER DOMAIN things ADD CONSTRAINT meow CHECK (VALUE < 11) > NOT VALID; Oooh, I hadn't realized that I was opening the door for domains and check constraints therein. I'll have a look at this. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
