Re: SQL queries from within PL/PERL triggers?

From: "Norman J(dot) Clarke" <norman(at)combimatrix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL queries from within PL/PERL triggers?
Date: 2001-01-12 21:19:03
Message-ID: Pine.LNX.4.21.0101121314120.4331-100000@curly.combimatrix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've seen this question asked several times in the last few months, but
never answered. Perhaps the answer is obvious to some, but unfortunately
it eludes me! It would be very helpful even to hear someone say "no it's
not possible" just to finally know for sure. So if you have any idea at
all, your reply would be most appreciated!

Regards,

Norm

> I ran across a few questions about this in the mailing list
> archive but I did not find any answers. I would like to create a trigger
> in PL/PERL that parses out information and sends queries from within the
> trigger. The only examples in the manual that use the stored perl
> functions return simple values and never send queries. Since the security
> features of PL/PERL do not allow for module importing (DBI) I am a bit
> clueless as to how this can be done if at all. Has anyone been able to do
> this?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2001-01-12 21:29:41 Re: php, time and postgresql
Previous Message Anthony E . Greene 2001-01-12 21:13:07 Re: timestamp update field across multiple tables