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.