From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Colin Beckingham <colbec(at)start(dot)ca> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: 1.15 Database Designer and character varying length option |
Date: | 2012-04-21 09:43:21 |
Message-ID: | 1335001401.2322.4.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Sat, 2012-04-21 at 05:15 -0400, Colin Beckingham wrote:
> I was using the Database Designer to make a copy of the design of some
> tables in one db for inclusion in a new db. The process worked well
> except that one of the tables in the source has a number of 'character
> varying' type columns without length specifier. Postgresql seems quite
> happy with this in the source db, however in the generated SQL the
> fields are marked varchar(0) which kills the execution of the SQL in the
> destination db.
>
Well, there is a strange bug in database designer. It seems to be
confused with precision and length. Apparently, it mixes them. A
numeric(2,5) would appear as a numeric(5,2). I wouldn't be surprised if
your problem has something to do with this (DD using precision (which a
text type doesn't have) instead of length).
So, yes, yet another bug in the database designer. I kinda feel that the
database designer won't be available in 1.16 because of bugs, some
design issues, and a lack of time to fix them.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Beckingham | 2012-04-21 10:11:14 | Re: 1.15 Database Designer and character varying length option |
Previous Message | Colin Beckingham | 2012-04-21 09:15:21 | 1.15 Database Designer and character varying length option |