serial datatype no longer working

General Discussion
1

Hi

Using postgreSQL database and liquibase 1.9 / 2.0 for a long time. When using the datatype serial for columns in these version worked as expected, creating a column with a defualt value taken from a sequence, created also.

But now I upgraded to 3.0.5, the serial column datatype is converted to int when the column is generated.
Why is that?
And more importantly: How can I get it to work as it did in the earlier versions?

-mads

2

I created https://liquibase.jira.com/browse/CORE-1559 to track the problem. The logic is there to go from “int+auto increment” -> serial but it isn’t handling it the other way.


As a work around you could define your column as and it will be created as serial, otherwise I’ll try to get the fix into 3.0.8.


Nathan