Connection Pooling

[enterprisedb]

Connection Pooling

[ibrarahmad]

You said:

The write user has all access on the write table and the read user only has select on the read table.
I then made two different tables one using the fdw_mysql_read server and one using the > fdw_mysql_write:

You have assigned permission to "read" and "write" user in MySQL? If yes then its MySQL responsibility to throw an error.

[ssmoss]

The issue was after accessing a table connected with the read server I could not insert data into the table connected to the write server.

If I disconnected from Postgres, reconnected and accessed the table connected with the write sever I then could not access the table associated with read server.

My use of the word server is in the context of "create server..."

[ibrarahmad]

I pushed a fix for that, can you please test that.

[ssmoss]

I will test this out today. Thanks.

[ssmoss]

I believe this is working correctly now.