Re: Writable foreign tables: how to identify rows - Mailing list pgsql-hackers

From Shigeru Hanada
Subject Re: Writable foreign tables: how to identify rows
Date
Msg-id CAEZqfEdWjd1oOyDjPuEZOU6k4Baf_=Fwm5g_Vp+FKpPBc57Opg@mail.gmail.com
Whole thread Raw
In response to Re: Writable foreign tables: how to identify rows  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: Writable foreign tables: how to identify rows  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-hackers
On Wed, Mar 6, 2013 at 12:35 PM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
> In the context of postgres_fdw, I am not sure if we need an additional
> system column like a node_id. Would there be a possibility where
> tuples to-be-modified are coming from different foreign tables and at
> runtime we need to decide where to execute the UPDATE/DELETE operation
> ? If we start supporting inheritance involving foreign tables as child
> tables, this will become a reality.

Foreign tables have tableoid system column which holds pg_class.oid of
the foreign table.  It seems sufficient to determine source server.

-- 
Shigeru HANADA



pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] Floating point error
Next
From: Bernd Helmle
Date:
Subject: Materialized View patch broke pg_dump