Skip to content

Issue with postgis types #393

@Sh4d1

Description

@Sh4d1

Hello! First, kudos, the lib seems very promising. I'm starting to use it, but hit an issue with a tables containing potgis data.
The initial sync works, but when switching to replication, it act as is the schema changed, and refuses to continue.
Here is the column mapping during the sync:

ColumnSchema { name: \"geom\", typ: Text, modifier: 1107480, nullable: true, primary: false }

Here it is for the replication:

 ColumnSchema { name: \"geom\", typ: Other(Other { name: \"unnamed_type(7805647)\", oid: 7805647, kind: Simple, schema: \"pg_catalog\" })

And the pipeline gets stuck with

{"type": "errored", "reason": "The schema for table 8015152 has
changed during streaming", "solution": "ETL doesn't support schema changes at this point in time, rollback the
schema", "retry_policy": {"type": "manual_retry"}}

Is this expected ? Any way to quick fix ?

Thanks!

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions