URL activation through trigger
Hi,
I am using Postgres 7.3.4. I want to write a trigger for
insert, update, delete operation on say, user table. This trigger will
activate an URL. URL will be as:
http://sandeep/Trigger?userid=4&name=sandeep where, userid and password
will be parameters to send. They may taken from database say, user
table. Is this possible ? How can I do that ?
Thanks & Regards,
Sandeep
Sandeep,
Using pl/perl at least, you could probably do this. My guess is that
pl/python (and perhaps pl/R) would offer similar functionality. At
least for pl/perl, I think you would need to use the untrusted version
and use a module like LWP. I haven't tried this, but I think it should
be possible (and fairly easy to do). Perhaps others can add some more
detail.
Sean
On Jan 27, 2005, at 9:38 AM, Sandeep Gaikwad wrote:
Show quoted text
Hi,
I am using Postgres 7.3.4. I want to write a trigger for
insert, update, delete operation on say, user table. This trigger will
activate an URL. URL will be as:
http://sandeep/Trigger?userid=4&name=sandeep where, userid and
password will be parameters to send. They may taken from database say,
user table. Is this possible ? How can I do that ?Thanks & Regards,
Sandeep---------------------------------------------------------
Disclaimer:
The contents of this message are confidential and intended to the
addressee at the specified e-mail address only. Its contents may not
be copied or disclosed to anyone other than the intended recipient. If
this e-mail is received in error, please contact Vertex Software Pvt.
Ltd immediately on +91 20 4041500 with details of the sender and
addressee and delete the e-mail. Vertex Software Pvt. Ltd accepts no
responsibility in the event that the onward transmission, opening or
use of this message and/or any attachments adversely affects the
recipient's systems or data. It is the recipient's responsibility to
carry out such virus and other checks as the recipient considers
appropriate.---------------------------------------------------------
---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org