Re: [GENERAL] dblink() from GridSQL

2011-05-06 Thread Mason S
> > > 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

Re: [GENERAL] dblink() from GridSQL

2011-05-05 Thread Sam Nelson
Grid passes functions off to underlying databases. Unfortunately, it doesn't do so when the functions are in the from clause. If it did, that would work. But I digress. We're attempting to try either the csv import (which would require a new script, but no biggie) or a data pull on the underlyi

Re: [GENERAL] dblink() from GridSQL

2011-05-05 Thread Scott Mead
On Thu, May 5, 2011 at 1:40 PM, Merlin Moncure wrote: > On Thu, May 5, 2011 at 12:13 PM, Sam Nelson > wrote: > > 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 d

Re: [GENERAL] dblink() from GridSQL

2011-05-05 Thread Merlin Moncure
On Thu, May 5, 2011 at 12:13 PM, Sam Nelson wrote: > 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 > i

[GENERAL] dblink() from GridSQL

2011-05-05 Thread Sam Nelson
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 see