pgsql: Support OID system column in postgres_fdw.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Support OID system column in postgres_fdw.
Date: 2016-08-26 13:34:19
Message-ID: E1bdHH1-0004Nl-Cn@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Support OID system column in postgres_fdw.

You can use ALTER FOREIGN TABLE SET WITH OIDS on a foreign table, but the
oid column read out as zeros, because the postgres_fdw didn't know about
it. Teach postgres_fdw how to fetch it.

Etsuro Fujita, with an additional test case by me.

Discussion: <56E90A76(dot)5000503(at)lab(dot)ntt(dot)co(dot)jp>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/ae025a15988f5491903cd3a2075f308c2773f711

Modified Files
--------------
contrib/postgres_fdw/deparse.c | 37 +++++++++++++++++-----
contrib/postgres_fdw/expected/postgres_fdw.out | 43 ++++++++++++++++++++------
contrib/postgres_fdw/postgres_fdw.c | 28 +++++++++++++++--
contrib/postgres_fdw/sql/postgres_fdw.sql | 13 +++++++-
4 files changed, 101 insertions(+), 20 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-08-26 14:07:40 pgsql: Fix logic for adding "parallel worker" context line to worker er
Previous Message Kevin Grittner 2016-08-26 12:34:32 Re: [COMMITTERS] pgsql: Add the "snapshot too old" feature