Re: SQL/MED - core functionality - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: SQL/MED - core functionality
Date
Msg-id AANLkTikzG7XvUajb=XBAgFZa67iupcXzPyFs1bMeTnMo@mail.gmail.com
Whole thread Raw
In response to Re: SQL/MED - core functionality  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: SQL/MED - core functionality  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, Dec 14, 2010 at 23:38, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Dec 14, 2010 at 1:16 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>>> On the other hand, I don't really see any advantage to allowing rules
>>> on foreign tables - ever.  Unless there's some reason we really need
>>> that, my gut feeling would be to rip it out and forget about it.
>>
>> views, updateable views?
>
> We already have those.  They have their own relkind.  Why would we
> need to duplicate that here?

We need RULEs or INSTEAD OF TRIGGERs to support updatable foreign tables.
Do you suggest to define a wrapper view if we want to create an updatable
foreign table? I think users don't like such kind of wrappers.

--
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: SQL/MED - core functionality
Next
From: Robert Haas
Date:
Subject: Re: SQL/MED - core functionality