<p><font face="Arial" size="2">Hello,</font><p><font face="Arial" size="2">I run pgAdmin III version 1.0.2 (Nov 28
2003)for windows and it work very well except in two situations.</font><p><font face="Arial" size="2">1.- When I have a
tablewith a text data type column and I want to change this data type to varchar then I can enter varchar data type but
Ican't enter data length because length text box is disabled.</font><p><font face="Arial" size="2">2.- Scripts
generatedfor a tables with check constraints don't have parentheses for the check expression. For example, for this
table:</font><p><fontface="Arial" size="2">CREATE TABLE public.llocs_treball<br /> (<br /> ...<br /> activitat_enfestiu
varchar(1)DEFAULT 'N'::character varying,<br /> ....<br /> CONSTRAINT llocs_treball_activitat_enfestiu CHECK (
activitat_enfestiu='S'OR activitat_enfestiu='N' ),<br /> ....<br /> ) WITHOUT OIDS;</font><br /><font face="Arial"
size="2">thepgAdmin generated script is:</font><br /><font face="Arial" size="2">CREATE TABLE public.llocs_treball<br
/>(<br /> ...<br /> activitat_enfestiu varchar(1) DEFAULT 'N'::character varying,<br /> ...<br /> CONSTRAINT
llocs_treball_activitat_enfestiuCHECK activitat_enfestiu::text = 'S'::text OR activitat_enfestiu::text = 'N'::text,<br
/>...<br /> ) WITHOUT OIDS;</font><p><font face="Arial" size="2">Platform:<br /> - pgAdmin III: Windows NT
workstation(service pack 6)<br /> - PostgreSQL: Linux miramar 2.6.5 #1 Thu May 27 17:40:27 CEST 2004 i686 GNU/Linux
(DebianSarge)</font><br /><font face="Arial" size="2">Language: Spanish</font><br /><font face="Arial"
size="2">Distribution:<br/> - pgAdmin III: version 1.0.2 (Nov 28 2003). Packages for MS Windows 2000/XP<br /> -
PostgreSQL:PostgreSQL 7.4.2 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.3 (Debian
20040401)</font><br/><font face="Arial" size="2">Thanks in advance,</font><p><font face="Arial" size="2">Pere
Rodríguez<br/> Dpt. d'Informàtica<br /> Hospital de Palamós<br /> Girona - Spain</font>
