Normalization Error: Failed to Normalize Records Due to Missing Column "id"

[tranquocduong]

I encountered an error when trying to normalize records in the public.Holidays table. The process fails with the following error message:

Normalization Error: failed to normalize records: error executing normalize statement for table public.Holidays: ERROR: column "id" does not exist (SQLSTATE 42703)

Database Engine: PostgreSQL Enviroment : Linux docker Schema Definition :

CREATE TABLE IF NOT EXISTS public."Holidays"
(
    "Id" uuid NOT NULL,
    "FromDate" timestamp with time zone,
    "ToDate" timestamp with time zone,
    "Repeat" boolean,
    "CreatedAt" timestamp with time zone,
    "UpdatedAt" timestamp with time zone,
    "CreatedBy" uuid,
    "UpdatedBy" uuid,
    "Year" integer,
    CONSTRAINT "Holidays_pkey" PRIMARY KEY ("Id")
)

Any insights or guidance on how to resolve this issue would be greatly appreciated!

[iamKunalGupta]

@tranquocduong what version of PeerDB are you running?

[tranquocduong]

I'm using v0.26.3

[heavycrystal]

is the destination peer also Postgres? looks like it

[tranquocduong]

yes. Postgres to Postgres and version temporalio is 1.27.0 When I create mirrors, the initial copy is successful, but when I create data, there is an error during synchronization.