| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodríguez Rodríguez, Pere | 2004-07-29 13:46:17 | Re: two bugs? |
| Previous Message | Daniel Struck | 2004-07-29 09:16:08 | Re: [ADMIN] Secure DB Systems - How to |