From: | "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es> |
---|---|
To: | "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: two bugs? |
Date: | 2004-07-29 13:46:17 |
Message-ID: | B35596C2EFF3D2118EE100A0C94B2A60014BFB07@palamos_nt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support |
>> 1.- When I have a table with a text data type column and I want to
>> change this data type to varchar then I can enter varchar data type but
>> I can't enter data length because length text box is disabled.
>
>It's not a bug, it's a feature: text has unlimited length, and pgadmin3
>won't allow you to decrease the length. You can go from varchar(5) to
>varchar(10) or varchar or text, but not varchar(4)
I'm agree but pgAdmin3 could allow modify it when there aren't any rows, or
if there are some row then pgAdmin3 could allow modify and then validate the
new data type and the data in the table. I supouse that the second option is
dificult, but is the first option possible?
>>
>> 2.- Scripts generated for a tables with check constraints don't have
>> parentheses for the check expression. For example, for this table:
>
>AFAIR this is fixed in CVS, please check a snapshot version.
Tanks very much, I tested 1.1.0 Devel snapshot version and it works fine.
Thanks in advance,
Pere Rodríguez
Dpt. d'Informàtica
Hospital de Palamós
Girona - Spain
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-07-29 19:08:59 | Re: two bugs? |
Previous Message | Hiroshi Saito | 2004-07-29 05:01:14 | Re: Assertion `G_TYPE_CHECK_INSTANCE (instance)' |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-07-29 18:00:10 | Re: [ADMIN] Secure DB Systems - How to |
Previous Message | Andreas Pflug | 2004-07-29 10:16:01 | Re: two bugs? |