Re: two bugs?
От | Rodríguez Rodríguez, Pere |
---|---|
Тема | Re: two bugs? |
Дата | |
Msg-id | B35596C2EFF3D2118EE100A0C94B2A60014BFB07@palamos_nt обсуждение исходный текст |
Ответ на | two bugs? ("Rodríguez Rodríguez, Pere" <prr@hosppal.es>) |
Ответы |
Re: two bugs?
|
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: