Issues

Select view

Select search mode

 
46 of 46

PostgreSQL primary key with autoIncrement causes "ERROR: both default and identity specified for column"

Description

When upgrading liquibase from 3.6.2 to any version 3.7.0 or higher, our migration scripts that used to work, now cause errors in postgres:

The previously working changeset looks like this:

I suspect the regression to come from the following PR: https://github.com/liquibase/liquibase/pull/874
Is this combination of primary key and autoincrement no longer supported?

I tried to find an upgrade guide for 3.7.0, but it seems these are no longer being created since 3.4 (last available is https://www.liquibase.org/v3_3_upgrade.html).

Environment

PostgreSQL 10.10
Liquibase 3.6.2 upgrade to 3.8.2 attempted. Verified 3.6.3 to still work, verified 3.7.0 to fail.

Details

Reporter

Affects versions

Priority

Created February 24, 2020 at 9:13 AM
Updated February 24, 2020 at 9:13 AM

Activity

Show:
Loading...