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.
--
---
Colin Beckingham
613-454-5369
http://www.it4gh.com