| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Nicolas Paris *EXTERN*'" <niparisco(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgres_fdw : disable extended queries |
| Date: | 2016-10-24 08:36:41 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B539610F9@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Paris | 2016-10-24 08:59:12 | Re: postgres_fdw : disable extended queries |
| Previous Message | Asif Naeem | 2016-10-24 06:32:46 | Re: Errors while installing PostGIS by an unusual method |