Sample Header Ad - 728x90

Using IMPORT FOREIGN SCHEMA with Greenplum database

0 votes
2 answers
209 views
I have setup a PostgreSQL 12 database and am trying to connect to a Greenplum database in order to create proxy tables. I am able to connect to the Greenplum db, but I get an error when I try to use the IMPORT FOREIGN SCHEMA command. IMPORT FOREIGN SCHEMA remote_schema FROM SERVER "remote_server" INTO schema_test_1; returns: ERROR: Greenplum Database does not support REPEATABLE READ transactions. (variable.c:570) CONTEXT: remote SQL command: START TRANSACTION ISOLATION LEVEL REPEATABLE READ SQL state: XX000 I read that REPEATABLE READ is not supported in Greenplum and to use SERIALIZE instead. Is there a way to edit the IMPORT FOREIGN SCHEMA command so that I can replace REPEATABLE READ with SERIALIZE? I am using PGadmin 4. Update: I found that I can get commands to work if I write them as complete transactions and include the following before any commands: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; Is there a way to set this as the default value for all transactions going through the Foreign Server?
Asked by Jason (1 rep)
Nov 11, 2019, 03:29 PM
Last activity: Jun 25, 2025, 04:04 PM