Don't update primary key

XiaoyongLin — Mon, 26 Jan 2026 16:26:21 GMT

my target database don't support update primary key

how can I set to filter primary key column.

eg:

the table has three columns: col1,col2,col3,the column col1 is primary key

when one update sql is running,replcate generate update sql like this

update test set col1=?,col2=?,col3=? where col1=?;

but I want to the sql like this:

update test set col2=?,col3=? where col1=?;

How should I set the table selectings

Re: Don't update primary key

abhijitnalekar — Thu, 07 Oct 2021 10:20:22 GMT

Can you please describe the requirement in detail?

The tabular format will be eaiser to understand.