0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.