two bugs?

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

Responses

Browse pgadmin-support by date

  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