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?