COMMENT ON CONSTRAINT <name> ON DOMAIN <domain>?

Hello,

I may be totally missing something, but there seems to be no way
to create a COMMENT on a domain constraint. There is

COMMENT ON CONSTRAINT constraint_name ON table_name

but no such thing for domain constraints, which seems like a
weird omission.

I couldn't find any relevant discussions on the list; is there a
technical reason this is not implemented?

Looking at the source, get_object_address() always assumes a
constraint is a table constraint. It seems to me that there is
a relatively easy fix:

COMMENT ON CONSTRAINT constraint_name ON DOMAIN domain_name,

then store constraint subject type (relation vs. domain) in
objname list, and handle that in get_object_address().

Thoughts?

Elvis

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers