dblink() from GridSQL

From: Sam Nelson <samn(at)consistentstate(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: dblink() from GridSQL
Date: 2011-05-05 17:13:49
Message-ID: BANLkTikfkhiMegUVUUbcmFQAcW5D+-5pPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List,

We have a customer who is trying to migrate a few PostgresPlus instances to
GridSQL clusters. They have a process that pulls data from another server
using dblink every night, and we're trying to replicate that on the GridSQL
instance, but grid is being a bit of a pain.

Grid doesn't seem to allow functions in from statements, and, of course, it
spits out errors about functions returning records being called in the wrong
context if we just try "select dblink(foo, bar);" (we had to try it).

Has anyone else run into this specific issue? Is there a known workaround?
Any ideas on what else we should try?
---
===========================
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===========================

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-05-05 17:40:58 Re: dblink() from GridSQL
Previous Message Andrew Sullivan 2011-05-05 17:01:31 Re: Cannot reproduce why a query is slow