search

EnterpriseDB / mysql_fdw

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

Transaction not supported #101

Open J20S opened 8 years ago

J20S commented 8 years ago

Hi,

I notice that transactions are not supported by mysql_fdw. For instance, say I have a table called customer in mysql: create table customer (custid INT nut null, name varchar(20));

In Postgresql, I just followed the processes described in the docomentation and created a foreign table customer. When I do the follow commands line by line: begin; insert into customer values (1, 'test'); rollback; the new record gets inserted once after the insert statement, and 'Rollback' doesn't work.

I have tested postgres_fdw with local Postgres server connecting with a remote Postgres server, transactions are working fine. If required, I can provide the steps that I have done to make it work.

Can you please consider adding the feature in future releases?

Cheers, Haitao

ahsanhadi commented 8 years ago

Hi, We don't yet have infrastructure in PG to support transactions involving external FDW's. A patch for this was sent to PG hackers sometime ago but it is not yet committed. Once we have this support in PG we will surely support transactions with mysql_fdw.

-- Ahsan

juliendoyon commented 4 years ago

Any improvement on this issue?

radik commented 1 month ago

Is there any update?

surajkharage19 commented 1 month ago

Hi,

If I understand correctly, you are looking for two phase commit feature in mysql_fdw. If my understanding is correct, then we do not have any immediate plan to support this in mysql_fdw. If you are willing to write a patch for the same then please submit a pull request, and we will review it.