Re: [GENERAL][UMN_MAPSERVER-USERS] query postgres AND oracle

2008-02-02 Thread Tom Lane
"John Smith" <[EMAIL PROTECTED]> writes: > thanks. thought dbi-link could only connect across postgres databases, > didn't realize it can connect postgres AND oracle. will look into it. No, you're confusing it with dblink, which is Postgres-specific. dbi-link relies on the Perl DBI layer, so it sh

Re: [GENERAL][UMN_MAPSERVER-USERS] query postgres AND oracle

2008-02-02 Thread John Smith
thanks. thought dbi-link could only connect across postgres databases, didn't realize it can connect postgres AND oracle. will look into it. jzs On 1/31/08, Chander Ganesan <[EMAIL PROTECTED]> wrote: > > John Smith wrote: > guys, > i got geometry in postgres, some other data in oracle. is it pos

Re: [GENERAL][UMN_MAPSERVER-USERS] query postgres AND oracle

2008-01-31 Thread Scott Marlowe
On Jan 31, 2008 1:38 PM, John Smith <[EMAIL PROTECTED]> wrote: > guys, > i got geometry in postgres, some other data in oracle. is it possible > to filter postgres geometry based on oracle data (without using > services)? You either import the data from oracle to pgsql and let the db do it (fastes

[GENERAL][UMN_MAPSERVER-USERS] query postgres AND oracle

2008-01-31 Thread John Smith
guys, i got geometry in postgres, some other data in oracle. is it possible to filter postgres geometry based on oracle data (without using services)? cheers, jzs ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster