Hello,
I run pgAdmin III version 1.0.2 (Nov 28 2003) for windows and it work very well except in two situations.
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.
2.- Scripts generated for a tables with check constraints don't have parentheses for the check _expression_. For example, for this table:
CREATE TABLE public.llocs_treball
(
...
activitat_enfestiu varchar(1) DEFAULT 'N'::character varying,
....
CONSTRAINT llocs_treball_activitat_enfestiu CHECK ( activitat_enfestiu='S' OR activitat_enfestiu='N' ),
....
) WITHOUT OIDS;
the pgAdmin generated script is:
CREATE TABLE public.llocs_treball
(
...
activitat_enfestiu varchar(1) DEFAULT 'N'::character varying,
...
CONSTRAINT llocs_treball_activitat_enfestiu CHECK activitat_enfestiu::text = 'S'::text OR activitat_enfestiu::text = 'N'::text,
...
) WITHOUT OIDS;
Platform:
- pgAdmin III: Windows NT workstation (service pack 6)
- PostgreSQL: Linux miramar 2.6.5 #1 Thu May 27 17:40:27 CEST 2004 i686 GNU/Linux (Debian Sarge)
Language: Spanish
Distribution:
- pgAdmin III: version 1.0.2 (Nov 28 2003). Packages for MS Windows 2000/XP
- PostgreSQL: PostgreSQL 7.4.2 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.3 (Debian 20040401)
Thanks in advance,
Pere Rodríguez
Dpt. d'Informŕtica
Hospital de Palamós
Girona - Spain
