shuttle-hq / synth

The Declarative Data Generator
https://www.getsynth.com/
Apache License 2.0
1.36k stars 105 forks source link

Error: We haven't implemented a converter for tsvector #414

Open seantalbot-jisc opened 1 year ago

seantalbot-jisc commented 1 year ago

Describe the bug Synth does not support postgres tsvector.

To Reproduce Steps to reproduce the behavior:

  1. Schema (if applicable)
CREATE TABLE title_version (
    id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    field_value VARCHAR(550) NOT NULL
   -- etc
);

ALTER TABLE
    title_version
ADD COLUMN
    field_value_ts_vector_english tsvector GENERATED ALWAYS AS (
        to_tsvector('english', lower(coalesce(field_value, '')))
    ) STORED;

When attempting to use synth to import the schema:

synth import --from <postgres-uri> --schema public testing
  1. See error
    Error: We haven't implemented a converter for tsvector

Expected behavior Synth should support tsvector when importing an existing postgres schema.

Screenshots If applicable, add screenshots to help explain your problem.

Environment (please complete the following information):

Additional context Add any other context about the problem here.