Rodríguez Rodríguez, Pere wrote:


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)



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.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to