Re: [SQL] URL activation through trigger

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@postgresql.org