Odd oid-system-column handling in postgres_fdw

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Odd oid-system-column handling in postgres_fdw
Date: 2016-03-16 07:25:42
Message-ID: 56E90A76.5000503@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

PG9.5 allows us to add an oid system column to foreign tables, using
ALTER FOREIGN TABLE SET WITH OIDS, but currently, that column reads as
zeroes in postgres_fdw. That seems to me like a bug. So, I'd like to
propose to fix that, by retrieving that column from the remote server
when requested. I'm attaching a proposed patch for that.

Best regards,
Etsuro Fujita

Attachment Content-Type Size
postgres-fdw-oid-support.patch application/x-patch 5.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-03-16 07:47:16 Re: Logical decoding slots can go backwards when used from SQL, docs are wrong
Previous Message Amit Kapila 2016-03-16 07:09:56 Pushdown target list below gather node (WAS Re: WIP: Upper planner pathification)