Re: FDW system columns - Mailing list pgsql-hackers

From Shigeru Hanada
Subject Re: FDW system columns
Date
Msg-id 4EC10F63.3020906@gmail.com
Whole thread Raw
In response to Re: FDW system columns  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: FDW system columns
List pgsql-hackers
(2011/11/14 11:25), Robert Haas wrote:
> My vote is to nuke 'em all.  :-)

+1.

IIRC, main purpose of supporting tableoid for foreign tables was to be
basis of foreign table inheritance, which was not included in 9.1, and
we have not supported it yet.  Other system columns are essentially
garbage, but they survived at 9.1 development because (maybe) it seemed
little odd to have system columns partially at that time.

So, IMHO removing all system columns from foreign tables seems
reasonable, unless it doesn't break any external tool seriously (Perhaps
there would be few tools which assume that foreign tables have system
columns).

If there seems to be a consensus on removing system column from foreign
tables, I'd like to work on this issue.  Attached is a halfway patch,
and ISTM there is no problem so far.

Regards,
--
Shigeru Hanada

Attachment

pgsql-hackers by date:

Previous
From: Kerem Kat
Date:
Subject: Re: (PATCH) Adding CORRESPONDING to Set Operations
Next
From: Thom Brown
Date:
Subject: Re: FDW system columns