From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Együd Csaba <csegyud(at)vnet(dot)hu> |
Cc: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Trigger isn't fired |
Date: | 2004-06-26 20:31:50 |
Message-ID: | 20040626132958.O75824@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 26 Jun 2004, [iso-8859-2] Együd Csaba wrote:
> Hi,
> I created a trigger function and a trigger with that function on a table. It
> is an "after insert or update or delete" trigger, in which I want to modify
> a second table regardless of the current modifications.
>
> Everything seems to be good on modifying the table, no error messages. After
> the modifications the second table isn't modified at all. Should anybody
> suggest me what I'm doing wrong? Does a trigger functon send error messages
> if it fails?
>
> My statements:
> --------------
> CREATE OR REPLACE FUNCTION trg_upd_prod_instock() RETURNS trigger AS '
> BEGIN
> perform ''update t_products set
> getup_instock=get_stock_getup(''||quote_literal(NEW.productid)||'',1) where
> id=''||quote_literal(NEW.productid);
I don't think this is going to do what you want. Are you sure you didn't
want EXECUTE rather than PERFORM?
From | Date | Subject | |
---|---|---|---|
Next Message | Ilia Kantor | 2004-06-26 21:38:33 | VACUUM technical question |
Previous Message | Cao, Wenhong | 2004-06-26 20:14:41 | Extract data from MySQL database using PostgreSQL |