Foward engineering and model comparation don't generate needed create sequence code

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Create a PostgreSQL database that has a table with a serial8 type field.
When you create the table it will be converted to BigInt Type and a
sequence will be automatically created for it being associated with it as
the default value.
2.Reverse engineer this table in Power*Architect. It will recognize the
field as BigInt and that the dafault value is the created sequence.
3.Try to forward engineer the model.
4.P*A won't generate the code for creation of the expected sequences, so
the fw engineer code won't be executable.

There are 2 options for solving this:

1-Try to make P*A "deduct" that this is a serial field, and generate the
field code as Serial8 insted of BigInt with a default value. This would be
possible only for default named sequences, I guess.
2-Make P*A, generate the code that creates the sequences before the table
code. (easy option)

Yet I would prefer the first one if it's possible

Original issue reported on code.google.com by nelson...@gmail.com on 1 Feb 2010 at 2:47

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Sorry, wrong issue list, please disconsider this isse.

Original comment by nelson...@gmail.com on 1 Feb 2010 at 2:59