postgres_fdw : disable extended queries

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: postgres_fdw : disable extended queries
Date: 2016-10-23 16:12:15
Message-ID: CA+ssMOT+jzdhHeZ1tTZjp=rerhkQP3_YTJu_6GLmJai0WN1mvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a 9.6 pg instance, and I am trying to link a foreign postgresql
database that do not accept extended queries. (only simple queries
https://www.postgresql.org/docs/current/static/protocol.html )

When I run a query against the foreign pg instance thought postres_fdw, it
looks like it sends a transaction containing

DECLARE c1 CURSOR FOR
SELECT customer_id FROM foodmart.customer

-> is there a way to run a simple query with postgres_fdw such:

SELECT customer_id FROM foodmart.customer

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-10-23 17:15:17 Re: Exclude pg_largeobject form pg_dump
Previous Message Guillaume Lelarge 2016-10-23 15:06:57 Re: Exclude pg_largeobject form pg_dump