Do Something before Abort on Trigger ??? - Mailing list pgsql-admin

From Yudha Setiawan
Subject Do Something before Abort on Trigger ???
Date
Msg-id 023f01c2bc75$bdce13b0$ea00a8c0@yudha
Whole thread Raw
Responses Re: Do Something before Abort on Trigger ???
Re: Do Something before Abort on Trigger ???
List pgsql-admin
Somebody gimme your hand plz.
 
Using my previous Database I used to be like that;
" ALTER TRIGGER tr_T_DtlPO ON dbo.T_DtlPO FOR UPDATE AS
  bla..bla..bla...
  IF @OldQty <> @NewQty BEGIN
     ROLLBACK
     INSERT INTO T_My_ListError(fc_code,fv_descript)
               VALUES('12345','No Authority to Change Qty')
  END"
So I'v already write the error code to table T_My_ListError before aborting this session
-----------------------------------------------------------------------------------------
And I Tried on Postgre like that;
" create or replace function fn_tr_t_dtlpo returns trigger as'
  begin
     bla..bla...;
     if new.fn_qty != old.fn_qty then
        raise exception ''Error 12345'';
        insert into t_my_listerror(fc_code,fv_descript)
                 values(''12345'',''No Authority to Change Qty'');
     end if;
  end;' language 'plpgsql';
"
But I Couldn't get any records at all on t_my_listerror. Even when put the insert statement
(insert into t_my_listerror...bla..bla) before raise exception.
 
Some advice will be very helpfull to me. Thank's a lot and ...
GOD Bless You All.
 

pgsql-admin by date:

Previous
From: "Yudha Setiawan"
Date:
Subject: Do Something before Abort on Trigger ???
Next
From: SAMTEK Consultores
Date:
Subject: Registering all User Operations