Re: FDW for PostgreSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FDW for PostgreSQL
Date
Msg-id 26146.1361460652@sss.pgh.pa.us
Whole thread Raw
In response to Re: FDW for PostgreSQL  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> Sure, it might fail if you use READ ONLY explicitly. Or the code might
> check it. The point is that one might not have choice about the READ
> ONLY state of the local transaction if its a HS standby as all
> transactions are READ ONLY there.

[ shrug... ]  If you want to use a remote DB to cheat on READ ONLY,
there's always dblink.  It's not apparent to me that the FDW
implementation should try to be complicit in such cheating.
(Not that it would work anyway given the command-level checks.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: FDW for PostgreSQL
Next
From: Kevin Grittner
Date:
Subject: Re: Materialized views WIP patch