On 31 May 2011 18:43, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > > Here it is -- as a context patch this time, as well. > > -- > Álvaro Herrera <alvhe...@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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; -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
