Обсуждение: ALTER DOMAIN feature request

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