AddAutoIncrement on Postgres does not work when changes are applied on a specific schema

Description

Hi,
I'm trying to use addAutoIncrement change on existing table in a specific schema (not public).
But it does not work since generated SQL does not contain schema name :

1 ALTER TABLE testschema.mytable ALTER COLUMN id SET DEFAULT nextval('mytable_id_seq');

It should be :

1 ALTER TABLE testschema.mytable ALTER COLUMN id SET DEFAULT nextval('testschema.mytable_id_seq');

I have no workaround to add sequence to my column. Does anyone have an idea ?

After investigating source, I see that in AddAutoIncrementChange for Postgres db, schema is not added to sequence name (line 110 on 3.3.0):

1 new AddDefaultValueStatement(catalogName, schemaName, getTableName(), getColumnName(), getColumnDataType(), new SequenceNextValueFunction(sequenceName))

Thanks.

Environment

Postgres

Status

Assignee

Unassigned

Reporter

Loïc Barbier

Labels

None

Components

Fix versions

Affects versions

3.3.0

Priority

Critical