1.15 Database Designer and character varying length option

From: Colin Beckingham <colbec(at)start(dot)ca>
To: pgadmin-support(at)postgresql(dot)org
Subject: 1.15 Database Designer and character varying length option
Date: 2012-04-21 09:15:21
Message-ID: 4F927AA9.2030809@start.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-04-21 09:43:21 Re: 1.15 Database Designer and character varying length option
Previous Message Radovan Jablonovsky 2012-04-20 22:40:19 pgadmin retrieving details about schema (700 objects) more than 5min