From: | "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es> |
---|---|
To: | "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | two bugs? |
Date: | 2004-07-29 08:04:27 |
Message-ID: | B35596C2EFF3D2118EE100A0C94B2A60014BFB06@palamos_nt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Struck | 2004-07-29 09:16:08 | Re: [ADMIN] Secure DB Systems - How to |
Previous Message | Greg Stark | 2004-07-28 20:16:10 | Re: [ADMIN] Secure DB Systems - How to |