From: | "Michal Kedziora" <michalkd(at)o2(dot)pl> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: raise exception and transaction handling |
Date: | 2007-07-29 11:33:25 |
Message-ID: | 002d01c7d1d4$475e41e0$3e01a8c0@michalk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi, Marcin
I'm not familiar with PREPARE TRANSACTION maby it could be done in that way.
But, you can use a EXCEPTION clause, and there put your insert.
IF EXISTS (SELECT 1 FROM g.m_lista WHERE idf = NEW.id) THEN
RAISE EXCEPTION 'CENY NIE SPELNIAJA WARUNKOW! %', rtrim(bledne);
END IF;
EXCEPTION
when RAISE_EXCEPTION then
INSERT INTO g.m_proba VALUES (1,2);
END;
It will work corect if you have only one RAISE EXCEPTION,becouse RAISE_EXCEPTION concern every exception called by RAISE command.
I hope that will help.
----- Origi
nal Message -----
From: Marcin Krawczyk
To: pgsql-sql(at)postgresql(dot)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 command in AFTER UPDATE TRIGGER. A piece of code:
BEGIN
-- some computations
bledne := (SELECT g.q_sumka('Poz.' || lps || ' - min. cena: ' || cena || ' ' || waluta ||'; ') FROM g.m_lista WHERE idf = NEW.id);
IF EXISTS (SELECT 1 FROM g.m_lista WHERE idf = NEW.id) THEN
RAISE EXCEPTION 'CENY NIE SPELNIAJA WARUNKOW! %', rtrim(bledne);
BEGIN
INSERT INTO g.m_proba VALUES (1,2); -- this is the operation I need to perform but the RAISE EXCEPTION above cancels it out
PREPARE TRANSACTION 'a';
COMMIT PREPARED 'a';
END;
END IF;
I tried to do it as shown above, with PREPARE and COMMIT but it's not working.
From | Date | Subject | |
---|---|---|---|
Next Message | roopa perumalraja | 2007-07-29 12:00:09 | increment the primary key value without using sequences |
Previous Message | Marcin Krawczyk | 2007-07-28 20:54:21 | raise exception and transaction handling |