ERROR: unterminated dollar-quoted string at or near "$set_timestamp$ BEGIN NEW.last_modified_date = CURRENT_TIMESTAMP" at character 71

[cheungyatho]

my trigger is like

CREATE OR REPLACE FUNCTION trigger_set_timestamp()
RETURNS TRIGGER AS $$
BEGIN
NEW.last_modified_date = CURRENT_TIMESTAMP;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;

I run it through ConnectionFactoryInitializer.
I am using docker Postgres:latest
Is it a bug?

[mp911de]

Thanks for reporting the issue. It's a duplicate of spring-projects/spring-framework#19999