dblink: enable parameters
Hello
I know so dblink is "deprecated" interface - but it has necessary
functionality still - it support a writable statements.
Very simple enhancing should be enable params to query - it's analogy
to USING clause in EXECUTE statement.
Regards
Pavel Stehule
On 22.11.2011 06:55, Pavel Stehule wrote:
I know so dblink is "deprecated" interface - but it has necessary
functionality still - it support a writable statements.
It would be nice to add support for SQL/MED "passthrough mode"... That
would allow you to do any queries/updates to foreign servers. It
wouldn't sound very difficult at first glance, though I'm not sure what
it would mean to our parser, for example.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
On Tue, Nov 22, 2011 at 20:09, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
It would be nice to add support for SQL/MED "passthrough mode"... That would
allow you to do any queries/updates to foreign servers. It wouldn't sound
very difficult at first glance, though I'm not sure what it would mean to
our parser, for example.
I think passthrough mode is almost impossible or has very limited usage
because we cannot pass query texts that our parser doesn't accept;
we cannot support foreign-table-specific queries.
On 22.11.2011 06:55, Pavel Stehule wrote:
I know so dblink is "deprecated" interface - but it has necessary
functionality still - it support a writable statements.
So, "dblink on FDW connection" seems to be a possible solution.
We pass a query as a form of a plain text.
--
Itagaki Takahiro
On 22.11.2011 06:55, Pavel Stehule wrote:
I know so dblink is "deprecated" interface - but it has necessary
functionality still - it support a writable statements.So, "dblink on FDW connection" seems to be a possible solution.
We pass a query as a form of a plain text.--
it is interesting idea
Pavel
Show quoted text
Itagaki Takahiro