Liquibase with EDB PostgreSQL

General Discussion
1

Hi All,

I'm doing a POC on Liquibase and EDB Postgresql. I'm getting following error when I try to deploy the changes 2nd time. I have to drop the log tables to continue deployment.

I enabled audit and found that Liquibase is trying to get the log table details and if not exists it is trying to create new tables.

In EDB postgres - tables are stored in LOWERCASE in metadata table - pg_class - where the Liquibase is checking for the log tables in UPPERCASE. I checked with EDB team , there is no configuration to change all tables to UPPERCASE..

Appreciate if you share any work around for this issue.

Here's the details-

liquibasedb=# select * from DATABASECHANGELOG;

id  |   author   |    filename    |      dateexecuted      | orderexecuted | exectype |               md5sum               | description | comments | tag | liquibase | contexts | labels | deployment_id

raw | includeAll | changeset2.sql | 20-APR-17 06:04:07.836 |             1 | EXECUTED | 7:20ea501c3e0062fc5ef2047b7ec53890 | sql         |          |     | 3.5.3     |          |        | 2693447821

(1 row)

liquibasedb=# select * from pg_class where relname='DATABASECHANGELOG';

relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated | relreplident | relfrozenxid | relminmxid | relacl | reloptions

(0 rows)

liquibasedb=# select * from pg_class where relname='databasechangelog';

      relname      | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated | relreplident | relfrozenxid | relminmxid | relacl | reloptions

|         2200 |   16743 |         0 |       10 |     0 |       16741 |             0 |        0 |         0 |             0 |         16744 | f           | f           | p              | r       |       14 |         0 | f          | f          | f           | f              | f              | f              | f                   | t              | d            |         2039 |          1 |        |

(1 row)