Support primary key not in first column

Question

Support primary key not in first column

gridpoint opened this issue a year ago · 1 comments

Hi team, if primary key is not in the first column. pg will raise exception "first column of remote table must be unique for INSERT/UPDATE/DELETE operation". In some way, we cannot change mysql table structure.

Answer 1 · 2023-11-29T07:14:34.000Z

Hi,

Currently, this is the limitation that the first column of remote table should be unique/primary key.
We will evaluate the possibility of overcoming this limitation in future but currently, that is not on our roadmap.