Skip site navigation (1) Skip section navigation (2)

Re: two bugs?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es>
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: two bugs?
Date: 2004-07-29 10:16:01
Message-ID: 4108CE61.4070401@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

  • two bugs? at 2004-07-29 08:04:27 from Rodríguez Rodríguez, Pere

pgadmin-support by date

Next:From: Rodríguez Rodríguez, PereDate: 2004-07-29 13:46:17
Subject: Re: two bugs?
Previous:From: Daniel StruckDate: 2004-07-29 09:16:08
Subject: Re: [ADMIN] Secure DB Systems - How to

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group