Postgresql foreign key across schema not recorded correctly

Description

We have a database with multiple schemas
schema-1 has a set of foreign keys against tables in schema-2 (we have been using liquibase a long time but cross schema foreign keys are a recent rearchitecting of our application)

When we diff the database for schema-1 against our production schema-1 database, the foreign keys are inappropriately flagged as differences. The yaml output for the difference is incorrect, as it does not populate the referencedTableSchemaName.

The exception to this is when the table containing the foreign key is a new table. In that case the yaml is correct with a correct referencedTableSchemaName and the output sql is correct.

Environment

linux postgresql 11.6 liquibase 3.8.3

Reporter

Colin Wilson

Components

Affects versions

Priority

Major
Configure