Support OID system column in postgres_fdw

Enterprise / PostgreSQL - Heikki Linnakangas [iki.fi] - 26 August 2016 08:33 UTC

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.5000503@lab.ntt.co.jp>

ae025a1 Support OID system column in postgres_fdw.
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(-)

Upstream: git.postgresql.org


  • Share