Skip site navigation (1) Skip section navigation (2)

1.15 DD - serial copied as integer

From: Colin Beckingham <colbec(at)start(dot)ca>
To: pgadmin-support(at)postgresql(dot)org
Subject: 1.15 DD - serial copied as integer
Date: 2012-04-21 15:06:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Database Designer copies serial fields as integer.

Basically the SQL generated by the DD is very helpful and saves a lot of 
work especially with respect to constraints and indexes since these 
operations are performed in the correct order. However workarounds 
require that the SQL be pasted into an editor, then:

1. change integer to serial as required
2. change varchar(0) to something more meaningful
3. inspect numeric (x,y) for accuracy
4. reorder fields as required.

Copy text to SQL editor and execute. Works.
Colin Beckingham

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-04-21 15:26:34
Subject: Re: 1.15 DD - order of columns
Previous:From: Colin BeckinghamDate: 2012-04-21 11:32:43
Subject: 1.15 DD - order of columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group