ALTER DOMAIN feature request

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

Browse pgsql-general by date

  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