Andrew Dunstan writes:
> I assume the proposal is to allow changing to a different server using
> the same FDW. I can see all sorts of odd things happening if we allow
> changing to a server of a different FDW.
As long as we check that the table's FDW options are acceptable to the
new FDW, where'
On Sep 30, 2017, at 10:58 PM, Andrew Dunstan wrote:
>
>
> On 09/30/2017 05:14 AM, Derry Hamilton wrote:
>> Just to say, yes, this would be handy. I've been using a variant of
>> that hack on reporting servers, while migrating systems from
>> proprietary databases. It behaves quite gracefully w
On Sat, Sep 30, 2017 at 03:58:04PM -0400, Andrew Dunstan wrote:
> On 09/30/2017 05:14 AM, Derry Hamilton wrote:
> > Just to say, yes, this would be handy. I've been using a variant of
> > that hack on reporting servers, while migrating systems from
> > proprietary databases. It behaves quite grace
On 09/30/2017 05:14 AM, Derry Hamilton wrote:
> Just to say, yes, this would be handy. I've been using a variant of
> that hack on reporting servers, while migrating systems from
> proprietary databases. It behaves quite gracefully when there are
> incompatible options, and it fixes up properly
Just to say, yes, this would be handy. I've been using a variant of that
hack on reporting servers, while migrating systems from proprietary
databases. It behaves quite gracefully when there are incompatible
options, and it fixes up properly with DROPs as the first options.
Derry
On Fri, Sep 29, 2017 at 10:19:03PM +0200, David Fetter wrote:
> On Fri, Sep 29, 2017 at 01:47:59PM -0400, Tom Lane wrote:
> > Konstantin Knizhnik writes:
> > > According to Postgresql documentation it is not possible to alter server
> > > for foreign table:
> > > https://www.postgresql.org/docs/1
On Fri, Sep 29, 2017 at 01:47:59PM -0400, Tom Lane wrote:
> Konstantin Knizhnik writes:
> > According to Postgresql documentation it is not possible to alter server
> > for foreign table:
> > https://www.postgresql.org/docs/10/static/sql-alterforeigntable.html
>
> Hmm, we'd have to check if the
Konstantin Knizhnik writes:
> According to Postgresql documentation it is not possible to alter server
> for foreign table:
> https://www.postgresql.org/docs/10/static/sql-alterforeigntable.html
Hmm, we'd have to check if the table's options were legal for the
new FDW, but in principle we could
