Creating a function fails

General Discussion
1

If I execute this code in postgresql:

    CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$
            BEGIN
                    RETURN i + 1;
            END;
    $$ LANGUAGE plpgsql;

It works fine from psql.
If I apply a file named dbchangelog.postgresql.sql like this:
–liquibase formatted sql
–changeset giovanni.martinez:1.function-create_corporation_dashboard
CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$
BEGIN
RETURN i + 1;
END;
$$ LANGUAGE plpgsql;
it fails with the following error:
Expected terminating $$ [Failed SQL: (0) CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$
I have the open source version. Just need to execute the SQL.
What did I do wrong?

2

Hi @datapro75

This worked for me, what version of liquibase are you using? I am using 4.2.0

ronak@Ronaks-MacBook-Pro postgres % liquibase --changeLogFile=4904.sql updateSQL
Liquibase Pro 4.2.0 by Datical licensed to Liquibase Pro Customer until Mon May 17 19:00:00 CDT 2021

Starting Liquibase at 09:08:41 (version 4.2.0 #18 built at 2020-11-13 16:49+0000)
– *********************************************************************
– Update Database Script
– *********************************************************************
– Change Log: 4904.sql
– Ran at: 1/6/21 9:08 AM
– Against: postgres@jdbc:postgresql://localhost:5432/postgres
– Liquibase version: 4.2.0
– *********************************************************************

SET SEARCH_PATH TO public;

– Lock Database
UPDATE public.databasechangeloglock SET LOCKED = TRUE, LOCKEDBY = ‘192.168.0.111 (192.168.0.111)’, LOCKGRANTED = ‘2021-01-06 09:08:42.211’ WHERE ID = 1 AND LOCKED = FALSE;

SET SEARCH_PATH TO public;

SET SEARCH_PATH TO public;

– Changeset 4904.sql::raw::includeAll
SET SEARCH_PATH TO public;

–changeset giovanni.martinez:1.function-create_corporation_dashboard
CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$
BEGIN
RETURN i + 1;
END;
$$ LANGUAGE plpgsql;

INSERT INTO public.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES (‘raw’, ‘includeAll’, ‘4904.sql’, NOW(), 6, ‘8:b3bb2cd856694b39111221e62211c05b’, ‘sql’, ‘’, ‘EXECUTED’, NULL, NULL, ‘4.2.0’, ‘9945722399’);

– Release Database Lock
SET SEARCH_PATH TO public;

UPDATE public.databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

SET SEARCH_PATH TO public;

Liquibase command ‘updateSQL’ was executed successfully.
ronak@Ronaks-MacBook-Pro postgres % liquibase --changeLogFile=4904.sql update

Starting Liquibase at 09:08:50 (version 4.2.0 #18 built at 2020-11-13 16:49+0000)
Liquibase: Update has been successful.
ronak@Ronaks-MacBook-Pro postgres %