Re: Reply: Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw - Mailing list pgsql-general

"=?gb18030?B?Z3V4aWFvYm8xOTgy?=" <guxiaobo1982@qq.com> writes:
> It works for insert and select statement under serializable level, but it seems update/delete statements are not
support,is that true? 
> template1=# update user_info set info='1234' where id=102;
> ERROR:  DECLARE CURSOR ... FOR UPDATE/SHARE is not supported
> DETAIL:  Cursors must be READ ONLY.

The postgres_fdw documentation says

    postgres_fdw can be used with remote servers dating back to
    PostgreSQL 8.3. Read-only capability is available back to 8.1.

I don't recall exactly when Greenplum forked off from Postgres, but
8.1 or so wouldn't surprise me.  The quoted error message looks about
like what you'd get when trying to use postgres_fdw with a pre-8.3
remote server.

            regards, tom lane