Re: [HACKERS] dblink: enable parameters
>> 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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] dblink: enable parameters
On Tue, Nov 22, 2011 at 20:09, Heikki Linnakangas 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] dblink: enable parameters
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers