Have users that are familiar with plpsql and have a process which needs to be done withing transactions in 2 databases. begin in db1 begin in db2
work on 1 work on 2
if work on both dbs worked
commit db1 commit db2
Do they need to use some other language (Java/Python)? How about a foreign data wrapper?
It's plpgsql, potentially with a slash, pl/pgsql.
You would have to use foreign data wrappers or dblink if you want a function to speak to a database other than the one it's calling session is attached to.
Your SO link references Oracle's language. It is called pl/SQL there. Neither one has "plpsql".
David J.
Have you looked at the dblink extension? That certainly give you the possibility to connect to more than one db.
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.