Skip to content

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

Description

@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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions