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:
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@xxxxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
