<p><font size="2">>> 1.- When I have a table with a text data type column and I want to </font><br /><font
size="2">>>change this data type to varchar then I can enter varchar data type but </font><br /><font
size="2">>>I can't enter data length because length text box is disabled.</font><br /><font
size="2">></font><br/><font size="2">>It's not a bug, it's a feature: text has unlimited length, and pgadmin3
</font><br/><font size="2">>won't allow you to decrease the length. You can go from varchar(5) to </font><br /><font
size="2">>varchar(10)or varchar or text, but not varchar(4)</font><p><font size="2">I'm agree but pgAdmin3 could
allowmodify it when there aren't any rows, or if there are some row then pgAdmin3 could allow modify and then validate
thenew data type and the data in the table. I supouse that the second option is dificult, but is the first option
possible?</font><p><fontsize="2">>> </font><br /><font size="2">>> 2.- Scripts generated for a tables with
checkconstraints don't have </font><br /><font size="2">>> parentheses for the check expression. For example, for
thistable:</font><br /><font size="2">></font><br /><font size="2">>AFAIR this is fixed in CVS, please check a
snapshotversion.</font><p><font size="2">Tanks very much, I tested 1.1.0 Devel snapshot version and it works
fine.</font><p><fontsize="2">Thanks in advance, </font><p><font size="2">Pere Rodríguez</font><br /><font size="2">Dpt.
d'Informàtica</font><br/><font size="2">Hospital de Palamós</font><br /><font size="2">Girona - Spain </font>