Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

createSequence does not work with PostgreSQL below 9.5

Description

Hello,
I am trying to run my migration scripts on newest Liquibase, and encountered the issue. Minimal changeset to reproduce is:

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd" logicalFilePath="changeLog.xml"> <changeSet author="my" id="TEST"> <createSequence schemaName="public" sequenceName="seq_name"/> </changeSet> </databaseChangeLog>

When it is running on my PostgreSQL 9.2 error is printed:

Unable to update database. liquibase.exception.MigrationFailedException: Migration failed for change set changeLog.xml::TEST::my: Reason: liquibase.exception.DatabaseException: ERROR: syntax error at or near "NOT" Position: 21 [Failed SQL: (0) CREATE SEQUENCE IF NOT EXISTS public.seq_name] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:646) ...

The reason is that CREATE SEQUENCE IF NOT EXISTS construction is available in PostgreSQL only since 9.5.

Liquibase versions before 3.8.1 are running it as expected.

Environment

Windows 10
PostgreSQL 9.2
Liquibase 3.8.1 till 3.8.5
Ant 1.10.5

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created January 14, 2020 at 11:15 AM
Updated January 14, 2020 at 11:15 AM