Skip to content
This repository has been archived by the owner on Dec 13, 2023. It is now read-only.

Conductor migration scripts does not work with Postgres 10 #260

Open
Akash47 opened this issue Sep 1, 2023 · 0 comments
Open

Conductor migration scripts does not work with Postgres 10 #260

Akash47 opened this issue Sep 1, 2023 · 0 comments

Comments

@Akash47
Copy link

Akash47 commented Sep 1, 2023

Describe the bug
Migration script is failing for V8__indexing.sql in postgres persistence. I am using postgres 10.
CREATE INDEX workflow_index_json_data_json_idx ON workflow_index USING gin(jsonb_to_tsvector('english', json_data, '["all"]'));
ERROR
org.postgresql.util.PSQLException: ERROR: function jsonb_to_tsvector(unknown, jsonb, unknown) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 76

Details
Conductor version: 3.13.8
Persistence implementation: Postgres

To Reproduce
Steps to reproduce the behavior:
deploy conductor-community server version 3.13.8
with postgres version 10.

Expected behavior
Server should start.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant