Обсуждение: dblink: enable parameters

Поиск
Список
Период
Сортировка

dblink: enable parameters

От
Pavel Stehule
Дата:
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


Re: dblink: enable parameters

От
Heikki Linnakangas
Дата:
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


Re: dblink: enable parameters

От
Itagaki Takahiro
Дата:
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


Re: dblink: enable parameters

От
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.
>
> 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

> Itagaki Takahiro
>