From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ALTER DOMAIN feature request |
Date: | 2010-05-14 20:46:36 |
Message-ID: | AANLkTilID_q3dcKPHkrpLSoto-rV29ACmH9Zf8BRja9W@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'd be nice is ALTER DOMAIN could combine multiple operations in a
single command similar to ALTER TABLE. I take it that this feature is
not included in the SQL standard?
Here is an example:
alter domain tag_sequence_type drop constraint
tag_sequence_type_check, add constraint tag_sequence_type_check CHECK(
value ~ E'^[A-Z]?$' );
ERROR: syntax error at or near ","
LINE 1: ...uence_type drop constraint tag_sequence_type_check, add cons...
^
Also I'd be nice if psql can show domain constraint names in the \dD
command. However, I see that the right answers can be found in the
domain_constraints information_schema.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
From | Date | Subject | |
---|---|---|---|
Next Message | Keaton_Adams | 2010-05-14 21:04:02 | Re: Poor query performance on one of two "like" databases in production. |
Previous Message | Julian Mehnle | 2010-05-14 20:42:30 | "--variable foo=bar" vs. "\set foo quux" in ~/.psqlrc |