SQL queries from within PL/PERL triggers?

From: Josh Goodman <jogoodma(at)lanl(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL queries from within PL/PERL triggers?
Date: 2001-01-11 19:51:43
Message-ID: Pine.GSO.4.10.10101111236380.3431-100000@helix.lanl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks in advance,
Josh Goodman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nelio Alves Pereira Filho 2001-01-11 19:52:53 Re: Modeling tool / ODBC
Previous Message Tom Lane 2001-01-11 19:48:42 Re: Casting money to numeric(10,2)