#StackBounty: #postgresql #greenplum #postgresql-fdw Postgres_fdw Transaction isolation issue

Bounty: 50

My case I have connected to another GP DB to import data into my PostgreSQL tables and written Java schedulers to refresh it Daily. But when I’m trying to fetch the records everyday by using SQL functions, it’s giving me an error Greenplum Database does not support REPEATABLE READ transactions. So, Can one suggest me how can I load data in frequent from GP to postgres without isolation hassle.

I knew to execute to refreh the tables by

START TRANSACTION ISOLATION LEVEL SERIALIZABLE;

But, I’m not able to use the same in the functions due to transactions blocks.


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.