|Subject:||Postgresql forcing query to run locally
|Date:||Mon, 20 Apr 2020 11:13:27 -0500
|From:||Mark Bannister <markRemove@THISinjection-moldings.com>
I'm trying to run some queries with local tables against remote
Something simple like:
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.