pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: cbell <cbell@lighthouseasp.com>
To: pgsql-sql@postgresql.org
Subject: Getting Results From Trigger
Date: Tue, 30 Jan 2001 11:50:43 -0500
Message-ID: <3A76F0E3.F6A4A5F0@lighthouseasp.com> (raw)


Hello everyone, I was hoping someone could help me with this...

I'm running postgres 7.02 on redhat 6.2, apache 1.3.14 and mod_perl
1.24_01.  I'm also using perl modules DBI 1.14 and DBD-Pg-0.95 to acces
the Postgres database.

Everytime my inventory file gets updated, I would like to have the
quantity on hand returned to my perl script.  I set up the following
function to do this:

CREATE FUNCTION inv_lookup () RETURNS OPAQUE AS '
BEGIN
RAISE  NOTICE ''%'', NEW.qtyonhand;
RETURN new;
end;
'language 'plpgsql';

Then I create the trigger like this...

CREATE TRIGGER qty after inventory for each row execute procedure
inv_lookup();

If I do any sort of updates from within psql I get the correct data
which is the Qtyonhand field in this format:

NOTICE:  15

However, in my perl program, I'm unsure as to how to get this
information back.  The Postgres Documentation says that the results from

a Notice get sent back to the application, but I check the DBI->err,
DBI->errstr, and DBI->state and they are empty.  The result code for the

actual SQL command I run is just 1 for success.

Does anyone know how to get these results from within a perl scripts???
Thanks in advance for any help.

Chris.






view thread (2+ messages)  latest in thread

Message-ID: <3A76F0E3.F6A4A5F0@lighthouseasp.com>
Permalink:  ../3A76F0E3.F6A4A5F0@lighthouseasp.com/
Also on:    postgresql.org/message-id/3A76F0E3.F6A4A5F0@lighthouseasp.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: cbell@lighthouseasp.com
  Subject: Re: Getting Results From Trigger
  In-Reply-To: <3A76F0E3.F6A4A5F0@lighthouseasp.com>
  References: <3A76F0E3.F6A4A5F0@lighthouseasp.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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