Suggestions for Remote Procedure Calls from PG, please?

From: Bret Schuhmacher <bret(at)thelastmilellc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Suggestions for Remote Procedure Calls from PG, please?
Date: 2007-10-18 02:30:26
Message-ID: 4716C542.6050402@thelastmilellc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----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 XMLBlaster to send a message to the
other box to start the other process, but that's an asynchronous call
and I can't be sure if the remote procedure ran properly.

Does anyone else invoke a process on a remote server? How do you do it?

Thanks,

Bret
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFHFsVCIeMC5lK637kRAvBvAKCRAgAg3H7jK/efm8KBlUKUifKV0ACgmo07
3eLZT6pB2XI8uTS47fdYcSw=
=rXIJ
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Armin Massa 2007-10-18 02:46:59 Re: Suggestions for Remote Procedure Calls from PG, please?
Previous Message Ow Mun Heng 2007-10-18 01:58:29 Re: Poor Plan selected w/ not provided a date/time but selecting date/time from a table