Overloaded functions not properly dropped in generated SQL

Applies to

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions

• Using PostgreSQL
• Using Liquibase version older than v4.32.0

Issue Summary

When using commands that generate SQL, such as diff-changelog and generate-changelog, in PostgreSQL and overloaded functions are present, the generated SQL output is invalid and causes exception errors when run.

Error Message

Example error message when trying to deploy generated SQL for an overloaded function.

ERROR: Exception Primary Class:  PSQLException
ERROR: Exception Primary Reason:  ERROR: syntax error at or near "DEFAULT"

Root Cause

PostgreSQL overloaded functions were not being properly dropped when Liquibase generated SQL, causing syntax errors in older Liquibase versions when the generated SQL is run.

Resolution

Update Liquibase to v4.32.0+.

The latest releases can be found on Liquibase.com and GitHub.