Re: FDW for PostgreSQL

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