Re: [v9.3] writable foreign tables - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [v9.3] writable foreign tables
Date
Msg-id CA+TgmoYStMSvn1HWL85ZKvFbObDLBLktuU4EekWu_vUqzM5uXw@mail.gmail.com
Whole thread Raw
In response to [v9.3] writable foreign tables  (Kohei KaiGai <kaigai@kaigai.gr.jp>)
Responses Re: [v9.3] writable foreign tables
List pgsql-hackers
On Thu, Aug 23, 2012 at 1:10 AM, Kohei KaiGai <kaigai@kaigai.gr.jp> wrote:
> It is a responsibility of FDW extension (and DBA) to ensure each
> foreign-row has a unique identifier that has 48-bits width integer
> data type in maximum.

It strikes me as incredibly short-sighted to decide that the row
identifier has to have the same format as what our existing heap AM
happens to have.  I think we need to allow the row identifier to be of
any data type, and even compound.  For example, the foreign side might
have no equivalent of CTID, and thus use primary key.  And the primary
key might consist of an integer and a string, or some such.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: TRUE/FALSE vs true/false
Next
From: Robert Haas
Date:
Subject: Re: temporal support patch