"=?gb18030?B?Z3V4aWFvYm8xOTgy?=" <guxiaobo1982@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
