Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AutoIncrement should convert to { INT | BIGINT } IDENTITY, instead of { SERIAL | BIGSERIAL } #249

Open
DJFarr opened this issue Jul 11, 2024 · 0 comments

Comments

@DJFarr
Copy link

DJFarr commented Jul 11, 2024

Hi,

I've seen this issue posted on the internet a few times, and even one issue in the liquibase repo which as been open for years (liquibase/liquibase#3505).

As stated, an INT or BIGINT column set to AutoIncrement: true in redshift should actually generate an IDENTITY column, as its the alternative to SEQUENCES.

I have connected to a new redshift instance, and put the driver and this extension in my liquibase/lib/ folder, and when i run liquibase update-sql the generated SQL contains SERIALs.

image

image

image

Doc:
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html
Examples:
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_examples.html

I felt like this was a better place for this issue to sit rather than the core repo.
I'm new to liquibase and this repo so I'm not confident enough yet to make my own PR.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant