pgcopydb icon indicating copy to clipboard operation
pgcopydb copied to clipboard

"relation does not exist" during online migration

Open shubhamdhama opened this issue 1 year ago • 1 comments

How to reproduce,

  1. After the snapshot is taken, create a table.
  2. Insert a row in new table

CDC of this table should be ignored on the client side

2024-01-24 10:44:03.551 20791 ERROR  pgsql.c:2038              [TARGET 2907] ERROR:  relation "public.table1" does not exist
2024-01-24 10:44:03.551 20791 ERROR  pgsql.c:2038              [TARGET 2907] LINE 1: INSERT INTO "public"."table1" ("col1", "col2", "col3") overr...
2024-01-24 10:44:03.551 20791 ERROR  pgsql.c:2038              [TARGET 2907]                     ^

shubhamdhama avatar Jan 24 '24 05:01 shubhamdhama

See #614 ; this issue should inform our design decisions in the linked PR.

dimitri avatar Jan 24 '24 11:01 dimitri