Postgres Pro
Downloads
Home   >   mailing lists

1.15 Database Designer and character varying length option - Mailing list pgadmin-support

From Colin Beckingham
Subject 1.15 Database Designer and character varying length option
Date
Msg-id 4F927AA9.2030809@start.ca
Whole thread Raw
Responses Re: 1.15 Database Designer and character varying length option  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: Radovan Jablonovsky
Date:
Subject: pgadmin retrieving details about schema (700 objects) more than 5min
Next
From: Guillaume Lelarge
Date:
Subject: Re: 1.15 Database Designer and character varying length option