Generated Columns break `pgbelt` - Githubissues

Autodesk / pgbelt

Pgbelt is a CLI tool used to manage Postgres data migrations from beginning to end, for a single database or a fleet, leveraging pglogical replication.

Apache License 2.0

18 stars 5 forks source link

Generated Columns break `pgbelt` #518

Open vjeeva opened 3 months ago

vjeeva commented 3 months ago

When a migration job involves tables with Postgres generated columns, pglogical replication goes down.

We see the following errors when doing setup, during the bulk COPY stage (before replication):

[13321]:ERROR: column "XXXXXXXXX" is a generated column
2024-07-15 15:45:05 UTC:DDD.DDD.DDD.DDD(EEEEEE):pglogical@YYYYYYYYYY:
[13321]:DETAIL: Generated columns cannot be used in COPY.

Soon after seeing this, we see pglogical replication status go down.

We need to figure out how to support generated columns with pglogical and pgbelt.

vjeeva commented 3 months ago

Ensure to document the lack of this support for generated columns