Re: writable FDWs / update targets confusion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: writable FDWs / update targets confusion
Date
Msg-id 22268.1386372305@sss.pgh.pa.us
Whole thread Raw
In response to Re: writable FDWs / update targets confusion  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-hackers
Tomas Vondra <tv@fuzzy.cz> writes:
> I think that we should make the documentation more explicit about this
> limitation, because the current wording in fdw-callbacks documentation
> seems to suggest it's possible to add such hidden columns. At least
> that's how I read it before running into this.

You can add hidden columns if you've got 'em ;-).  What's missing
is the ability to create any hidden columns other than the ones in
standard PG tables.  What we most likely need is the ability for
an FDW to override the type assigned to the CTID column at foreign
table creation.  (We'd then also need to think about where such a
column could be shoehorned into a tuple, but the catalog support
has to come first.)  Alternatively, it might work to append "junk" columns
in the user column numbering domain, which would only exist in runtime
tuple descriptors and not in the catalogs.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WITHIN GROUP patch
Next
From: Andrew Gierth
Date:
Subject: Re: WITHIN GROUP patch