search

dimitri / pgcopydb

Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)
Other
1.16k stars 76 forks source link

CDC update on tables with column type as "generated always as identity" fails #844

Open arajkumar opened 2 months ago

arajkumar commented 2 months ago

Updating a row value in the following schema fails with error

create table metrics( "SerialNumber" integer generated always as identity, name text);
ERROR:  column "SerialNumber" can only be updated to DEFAULT
DETAIL:  Column "SerialNumber" is an identity column defined as GENERATED ALWAYS.

Currently, we handle only: