Paradox Community

Items in pnews.paradox-client_server

Subject:Postgresql forcing query to run locally
Date:Mon, 20 Apr 2020 11:13:27 -0500
From:Mark Bannister <>
I'm trying to run some queries with local tables against remote
postgresql server.

Something simple like:
FROM ':PRIV:__pncopy' o
LEFT JOIN ':manager:partnum' p
on =

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