Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql forcing query to run locally
Date:Tue, 21 Apr 2020 11:29:23 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
The joys of using PostgreSQL as a pseudo Paradox database. To run on the 
server, everything required needs to be visible to Postgres. I keep 
harping back on this point - trying to combine Paradox tables and 
PostgreSQL tables in a datamodel or query is a bad idea.

On 21/04/2020 2:13 am, Mark Bannister wrote:
> I'm trying to run some queries with local tables against remote
> postgresql server.
> 
> Something simple like:
> SELECT o.*
> FROM ':PRIV:__pncopy' o
> LEFT JOIN ':manager:partnum' p
> on p.id = o.id
> 
> Where "manager" alias is postgresql server  alias.
> 
> When executesql is called  and I define the database as "PRIV" then it
> runs locally, but it asks for a password for the "manager" alias.
> "Manager" has already been open.
> If I define the database as "manager" then it sends the query to the
> postgresql server which obviously doesn't know anything about files in
> the private directory.  I tried making and postgresql alias defined to
> run locally only but that has no effect on this issue.
> --
> Mark B
> 


Copyright © 2004 thedbcommunity.com