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