Roll on the time when I can write triggers in Perl for PostgreSQL - This is probably the only element missing from the embedded plperl/plperlu solution provided by PostgreSQL.
Re:mind if i ask...
rob_au on 2003-08-04T23:49:17
As it is, I am wanting to employ Perl triggers within some code that I am working on within an enterprise environment whereby, the addition of mail receipt details to a central database initiates processing based upon these details.This processing relates to the Allowed Senders and Blocked Senders list lookups, the issuing of verification requests and mailbox delivery of mail from mail queues associated with the Bluebottle Verification System. The incorporation of Perl triggers within the database and application server environment would allow for the distinct separation of mail exchangers, web frontends and backend database/application server components within this system.
I have considered extproc_perl and Oracle, but at this stage, I do not believe that our development upon this enterprise product is far enough along at this stage to justify the overhead (and cost) of an Oracle database.
Re:mind if i ask...
jhorwitz on 2003-08-05T00:07:28
yeah, it costs a *bit* more than postgresql.:P
