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