Netflix / conductor-community

Apache License 2.0
61 stars 71 forks source link

Conductor migration scripts does not work with Postgres 10 #260

Open Akash47 opened 10 months ago

Akash47 commented 10 months ago

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.