Re: 1.15 Database Designer and character varying length option

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