Re: Writable foreign tables: how to identify rows

Поиск
Список
Период
Сортировка
От Shigeru Hanada
Тема Re: Writable foreign tables: how to identify rows
Дата
Msg-id CAEZqfEebcZ8DvBL2dsnq_zwypqGpYxxye5T4m8_aQnBZZJCkCw@mail.gmail.com
обсуждение исходный текст
Ответ на Writable foreign tables: how to identify rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Writable foreign tables: how to identify rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Mar 6, 2013 at 9:30 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> For postgres_fdw, that would really be enough, since it could just
> cause a "ctid" column to be created with the usual definition.  Then
> it could put the remote ctid into the usual t_self field in returned
> tuples.

I'm not sure whether postgres_fdw should support, but updatable views
have no system column including ctid.  So, we need magic identifier,
perhaps it would be set of primary key value(s), to support updating
remote updatable views via foreign tables.

Just a heads up.

-- 
Shigeru HANADA



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: Writable foreign tables: how to identify rows
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Support for REINDEX CONCURRENTLY