| 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: | Whole Thread | Raw Message | 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 |