Skip to content

Autoincrement Fields for Postgresql #54

Description

@fdesp87

Autoincrement fields (in Postgresql terminology smallserial, serial or bigserial) are mapped in the schema correctly to smallint, integer and bigint. If some of these fields is primary key, it is also correctly marked.

But when extracting the information from the Postgresql database, the autoincrement property is not marked at all in the generated schema.

This situation must be corrected, for example by including a new field property (named Serial) and then set it depending upon the information returned by Postgresql. Obviously the function “is_autoincrement” has to be modified. The python module dborm.py has to be modified too, admitting now in the third column the key “PK,SERIAL” for smallint, integer and bigint.

For more explanations, you can read the report
https://github.com/fdesp87/gnatcoll-db/examples/mytests/Report.odt

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions