Thread: 1.15 DD - serial copied as integer

1.15 DD - serial copied as integer

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