From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DOMAIN usability |
Date: | 2003-11-14 18:13:26 |
Message-ID: | 3FB51B46.3080708@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-11-14 18:26:12 | Re: Storage consumption |
Previous Message | Richard Huxton | 2003-11-14 18:11:04 | Re: Loggin SQL Statements from JBOSS/JDBC |