Liquibase Error with Changeset

General Discussion
1

Hello,

I am new to Liquibase deploys, We have started using Liquibase for our deploys to Amazon RDS using SQL format for changesets. I had to deploy a changeset and while it worked locally, seems like I am getting DatabaseException Error when deploying to a NonProd Environment. It is erroring with Identity Insert within a SP .

liquibase.exception.DatabaseException: An explicit value for the identity column in table

In the Same changeset, I do have the change for the Tables to be dropped and recreated without the Identity Column.

Since it is SQL file and I can’t specify runOrder for the changesets, is there a way to get around this by having it drop and recreate the tables before altering the SP?
Structure we have in Liquibase is as follows:
SchemaName
Procedures
Tables

In SQL, I can do a quick drop and recreate of the tables and then, apply the SP changes.

Please note, we have a Liquibase Basic and not the PRO license, hence, we are trying to do these all via SQL files for deploys.

Appreciate any guidance, thanks

2

If you are using a Formatted SQL changelog, you can add another change set with a “table exists” precondition that comes before the create table changeset, and drop the table there.

Or is your changelog just raw SQL?

3

Thanks Willard, I had gone with the approach of splitting the Stored Proc changes to the table changes.