pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedURL activation through trigger
2+ messages / 2 participants
[nested] [flat]
* URL activation through trigger
@ 2005-01-27 14:38 Sandeep Gaikwad <sgaikwad@vertex.co.in>
2005-01-27 15:07 ` Re: [SQL] URL activation through trigger Sean Davis <sdavis2@mail.nih.gov>
0 siblings, 1 reply; 2+ messages in thread
From: Sandeep Gaikwad @ 2005-01-27 14:38 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org
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.
---------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] URL activation through trigger
2005-01-27 14:38 URL activation through trigger Sandeep Gaikwad <sgaikwad@vertex.co.in>
@ 2005-01-27 15:07 ` Sean Davis <sdavis2@mail.nih.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Sean Davis @ 2005-01-27 15:07 UTC (permalink / raw)
To: Sandeep Gaikwad <sgaikwad@vertex.co.in>; +Cc: pgsql-general@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-01-27 15:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-27 14:38 URL activation through trigger Sandeep Gaikwad <sgaikwad@vertex.co.in>
2005-01-27 15:07 ` Sean Davis <sdavis2@mail.nih.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox