Em Thursday 18 October 2007 01:44:33 Bret Schuhmacher escreveu:
Thanks for the reply, Tom. I was thinking I could have my remote
process send a message back to PG via XMLBlaster, too. XMLBlaster is
a MOM-like message-queuing app that guarantees delivery to
subscribers. (www.xmlblaster.org).
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What's the best way to invoke a process on another server from a PG
trigger or procedure? I was thinking of using pl/java to invoke a web
service on the other box... Can pl/tcl run Expect scripts? That'd be
an option, too. Or I could use
Bret,
I had quick and robust success using pl/python and pyro. Pyro is
Python Remote object.
All mentioned modules are BSD-like in license.
Harald
What's the best way to invoke a process on another server from a PG
trigger or procedure? I was thinking of using pl/java to invoke a web
Bret Schuhmacher [EMAIL PROTECTED] writes:
What's the best way to invoke a process on another server from a PG
trigger or procedure? I was thinking of using pl/java to invoke a web
service on the other box... Can pl/tcl run Expect scripts?
No, but pl/tclu could.
Or I could use XMLBlaster
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
You've almost figured out the big problem with anything like this;
the trouble spot is the other way around. What if you launch some
remote operation, and it succeeds, and then later your own transaction
rolls back for some
am Wed, dem 17.10.2007, um 22:30:26 -0400 mailte Bret Schuhmacher folgendes:
Does anyone else invoke a process on a remote server? How do you do it?
You can use any untrusted programming language like pl/perlU or plsh.
Other solution: use LISTEN/NOTIFY, see
What's the best way to invoke a process on another server from a PG
trigger or procedure? I was thinking of using pl/java to invoke a web
service on the other box... Can pl/tcl run Expect scripts? That'd be
an option, too. Or I could use XMLBlaster to send a message to the
other box to