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