On Tue, Nov 5, 2019 at 7:41 PM David Fetter wrote:
> Could you use IMPORT FOREIGN SCHEMA for that? I seem to recall that
> I've managed to import information_schema successfully.
Yes, I tried it and I can import and operate on the
information_schema, which actually covers part of my needs. It doe
On Tue, Nov 05, 2019 at 11:09:34AM +0100, rto...@carto.com wrote:
> On Sun, Oct 27, 2019 at 7:07 PM David Fetter wrote:
> > There's a SQL MED standard feature for CREATE ROUTINE MAPPING that
> > does something similar to this. Might it be possible to incorporate
> > it into the previous patch tha
> On Fri, Oct 25, 2019 at 12:38 PM Tom Lane wrote:
> > end of things. And allowing arbitrary queries to go over a postgres_fdw
> > connection would be absolutely disastrous from a debuggability and
> > maintainability standpoint, because they might change the remote
> > session's state in ways th
On Sun, Oct 27, 2019 at 7:07 PM David Fetter wrote:
> There's a SQL MED standard feature for CREATE ROUTINE MAPPING that
> does something similar to this. Might it be possible to incorporate
> it into the previous patch that implemented that feature?
Supporting CREATE ROUTINE MAPPING goes a leve
On Fri, Oct 25, 2019 at 12:38 PM Tom Lane wrote:
> end of things. And allowing arbitrary queries to go over a postgres_fdw
> connection would be absolutely disastrous from a debuggability and
> maintainability standpoint, because they might change the remote
> session's state in ways that postgre
On Sun, Oct 27, 2019 at 7:07 PM David Fetter wrote:
>
> There's a SQL MED standard feature for CREATE ROUTINE MAPPING that
> does something similar to this. Might it be possible to incorporate
> it into the previous patch that implemented that feature?
Thanks for the idea, David. I'll investigat
On Fri, Oct 25, 2019 at 05:17:18PM +0200, rto...@carto.com wrote:
> Dear all,
>
> We stumbled upon a few cases in which retrieving information from the
> foreign server may turn pretty useful before creating any foreign
> table, especially info related to the catalog. E.g: a list of schemas
> or t
rto...@carto.com writes:
> We stumbled upon a few cases in which retrieving information from the
> foreign server may turn pretty useful before creating any foreign
> table, especially info related to the catalog. E.g: a list of schemas
> or tables the user has access to.
> I thought of using dbli
Dear all,
We stumbled upon a few cases in which retrieving information from the
foreign server may turn pretty useful before creating any foreign
table, especially info related to the catalog. E.g: a list of schemas
or tables the user has access to.
I thought of using dblink for it, but that requ
