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