search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
521 stars 160 forks source link

Support primary key not in first column #282

Open gridpoint opened 7 months ago

gridpoint commented 7 months ago

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.

surajkharage19 commented 7 months ago

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.