ALTER DOMAIN feature request

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема ALTER DOMAIN feature request
Дата
Msg-id AANLkTilID_q3dcKPHkrpLSoto-rV29ACmH9Zf8BRja9W@mail.gmail.com
обсуждение исходный текст
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Poor query performance on one of two "like" databases in production.
Следующее
От: Julian Mehnle
Дата:
Сообщение: "--variable foo=bar" vs. "\set foo quux" in ~/.psqlrc