Re: [SQL] raise exception and transaction handling

2007-07-30 Thread Bart Degryse
hope that will help. - Origi nal Message - From: Marcin Krawczyk ( mailto:[EMAIL PROTECTED] ) To: pgsql-sql@postgresql.org Sent: Saturday, July 28, 2007 10:54 PM Subject: [SQL] raise exception and transaction handling Hi, I have a problem with transaction handling. What I need to do

Re: [SQL] raise exception and transaction handling

2007-07-29 Thread Michal Kedziora
: Marcin Krawczyk To: pgsql-sql@postgresql.org Sent: Saturday, July 28, 2007 10:54 PM Subject: [SQL] raise exception and transaction handling Hi, I have a problem with transaction handling. What I need to do is execute an INSERT command that would not be canceled by the RAISE EXCEPTION

[SQL] raise exception and transaction handling

2007-07-28 Thread Marcin Krawczyk
Hi, I have a problem with transaction handling. What I need to do is execute an INSERT command that would not be canceled by the RAISE EXCEPTION command in AFTER UPDATE TRIGGER. A piece of code: BEGIN -- some computations bledne := (SELECT g.q_sumka('Poz.' || lps || ' - min. cena: ' || cena || '