On Sat, 26 Jun 2004, [iso-8859-2] Együd Csaba wrote:
> 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 '
> perform ''update t_products set
> getup_instock=get_stock_getup(''||quote_literal(NEW.productid)||'',1) where
I don't think this is going to do what you want. Are you sure you didn't
want EXECUTE rather than PERFORM?
In response to
pgsql-general by date
|Next:||From: Ilia Kantor||Date: 2004-06-26 21:38:33|
|Subject: VACUUM technical question|
|Previous:||From: Cao, Wenhong||Date: 2004-06-26 20:14:41|
|Subject: Extract data from MySQL database using PostgreSQL|