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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
