Re: DOMAIN usability - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: DOMAIN usability
Date
Msg-id Pine.LNX.4.44.0311131848190.17499-100000@peter.localdomain
Whole thread Raw
In response to DOMAIN usability  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: DOMAIN usability  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-general
Rajesh Kumar Mallah writes:

> *1.* Suppose varchar(30) turns out to be too small oneday
>     and we want to increase it to varchar(100)  , what do i do ?

This is no different from the problem of changing a column type in place.
It's still being worked on.

> *2.* Its difficult to see all the constraint defs on a domain .
>     information_schema.domain_constriants does not have the
>    definations just the names are present.

You need to join domain_constraints and check_constraints.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: Curious about exclusive table locks
Next
From: Tom Lane
Date:
Subject: Re: Curious about exclusive table locks