search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
530 stars 162 forks source link

Cannot Update with Composite Primary Key From pgSQL to MySQL #130

Open fungfungsm opened 7 years ago

fungfungsm commented 7 years ago

I have configured and install the FDW in the pgsql and connect the MySQL successfully. But, when I use the pgAdmin to update a record in MySQL DB. It cannot support or have bug with composite PK. it just get a single column for PK. I have checked the log file in MySQL. The flow is get the value by prepare for update, then using the prepare statement the execute the update query.

How can I fix it or this is a constrain?

ahsanhadi commented 7 years ago

Are you able to run your test case successfully from psql and only face the issue when you do it via pgadmin?

On Mon, Feb 27, 2017 at 3:12 PM, fungfungsm notifications@github.com wrote:

I have configured and install the FDW in the pgsql and connect the MySQL successfully. But, when I use the pgAdmin to update a record in MySQL DB. It cannot support or have bug with composite PK. it just get a single column for PK. I have checked the log file in MySQL. The flow is get the value by prepare for update, then using the prepare statement the execute the update query.

How can I fix it or this is a constrain?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/130, or mute the thread https://github.com/notifications/unsubscribe-auth/AHmqpFbu-1C3ww3AvstrbU6_wlcUMwz2ks5rgqGrgaJpZM4MM6ts .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 Mobile: +92-333-5162114

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

fungfungsm commented 7 years ago

It is not only have problem in pgadmin, but also have the problem in the ADODB with php.