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   [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to