Re: FDW-based dblink (WIP) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FDW-based dblink (WIP)
Date
Msg-id 22571.1250695764@sss.pgh.pa.us
Whole thread Raw
In response to Re: FDW-based dblink (WIP)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: FDW-based dblink (WIP)  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: FDW-based dblink (WIP)  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2009/8/19 Tom Lane <tgl@sss.pgh.pa.us>:
>> I don't believe there is any consensus for integrating dblink into core,
>> and I for one will resist that strongly.  Keep it in contrib.

> if integration means, so I could to write query like
> SELECT * FROM otherdatabase.schema.table ....
> UPDATE otherdb.table SET ...
> I am for integration.

That is not what "integrating dblink" means --- what Itagaki-san is
talking about is moving the dblink_xxx functions into core.  What
you are talking about is actual SQL/MED functionality, which we should
indeed try to get into core someday.  But dblink is a dead end as far
as standards compliance goes.  Between that and the potential security
issues, we should not put it in core.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: FDW-based dblink (WIP)
Next
From: Heikki Linnakangas
Date:
Subject: Re: FDW-based dblink (WIP)