On Mon, Nov 03, 2008 at 10:02:24AM -0300, Alvaro Herrera wrote:
> David Fetter wrote:
>
> > However, there are little lacunæ like this:
> >
> > SELECT * FROM show_qual() s(a)
> > WHERE A NOT IN (
> > SELECT 'foo' UNION ALL SELECT 'bar'
> > );
> > a
> > ------------------------
> > (NOT (hashed subplan))
>
> This little lacuna seems to say that if you pass the wrong query to
> dblink, it will fail to work, possibly with a very obscure error
> message; it will be very difficult to debug, and also very difficult
> (if not impossible) to workaround.
I understand that a full implementation of SQL/MED will involve just
about every part of PostgreSQL, but we've got a case of "le mieux est
l'enemi du bien" with this contrived example, which I included so
people could be fully informed when using this very helpful new
feature. Left out are the very large benefits that, for example,
dblink gets for free.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate