transactions not working properly ?

From: Ali Baba <idofyear(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: transactions not working properly ?
Date: 2005-08-17 12:53:14
Message-ID: 20050817125314.56244.qmail@web52506.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
can any one describe how the transaction are being
handled in postgres.
i.e.
function given below should actually insert the desire
values in test table but it do not save them.
START TRANSACTION;
create or replace function testFunc() returns int as
$$
declare
x integer;
begin
x := 1;
insert into test values (210,20);
x := x/0;

RETURN 0;

exception
when others then
raise info 'error generated ';
commit;
RETURN 0;
end;
$$ language plpgsql;

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-08-17 12:53:48 Re: Upcoming back-branch releases
Previous Message Tatsuo Ishii 2005-08-17 12:43:19 Re: obtaining row locking information