Re: DOMAIN usability
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
Import Notes
Reply to msg id not found: 3FB50FC6.5000009@trade-india.com
On Fri, 14 Nov 2003 23:43:26 +0530
Rajesh Kumar Mallah <mallah@trade-india.com> wrote:
BTW: Searching on archives.postgresql.org takes ages is it using FTS?
Groups.google.com has indexes of the mailing lists so you can use that
to search. I do because archives is unusably slow.
you know. we should do something about that :)
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
Import Notes
Reply to msg id not found: 3FB51B46.3080708@trade-india.com
Peter Eisentraut wrote:
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.
Yes i realize so. But what could be in principle wrong to allow increasing
storage size only eg varchar(30) to varchar(100) not integer to
varchar(100)
etc. I remeber there was already a long thread of discussion on it.
BTW: Searching on archives.postgresql.org takes ages is it using FTS?
*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.
thanks.
Regds
Mallah.
--
Rajesh Kumar Mallah,
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.