Re: [9.3] Automatically updatable views vs writable foreign tables - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: [9.3] Automatically updatable views vs writable foreign tables
Date
Msg-id CAEZATCWrK9Nn-bS75mzi8kzv7-WRGUMN-akW0q+kzk+2Yrn0og@mail.gmail.com
Whole thread Raw
In response to Re: [9.3] Automatically updatable views vs writable foreign tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 16 May 2013 22:16, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> This is assuming that an FDW that defines, say, ExecForeignDelete
> is thereby promising that *all* tables it supports are deletable.  That
> is not required by the current FDW API spec.
>

Ah OK, I didn't appreciate that distinction.

> If we want to do something about this, I'd be a bit inclined to say that
> we should add a new FDW callback function to let the FDW say whether
> a particular rel is updatable or not.
>
> I think it would be a good idea to get that done for 9.3, since all this
> support is new in 9.3, and it's not too late to adjust the API now.
> If we wait, there will be compatibility headaches.
>

+1. That seems like something that should be part of the API, even if
we didn't have an immediate use for it.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [9.3] Automatically updatable views vs writable foreign tables
Next
From: Paul Hammond
Date:
Subject: PLJava for Postgres 9.2.