Nicolas Paris wrote: > 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 No, it is part of the design that cursors are used, so that rows can be fetched one at a time and concurrent DML statements can be run. You might consider using dblink. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
