Hi Michael,
i want to support explicit commit/rollback support
in pl/pgsql instead of using autocommit feature.
my requirement is to know how transactions work in
postgres generally and how to support transaction
managment in pl/pgsql
thanks for your help.
--
Asif Ali.
--- Michael Fuhr
Ali Baba wrote:
Hi Michael,
i want to support explicit commit/rollback support
in pl/pgsql instead of using autocommit feature.
The fine manual is your friend:
http://www.postgresql.org/docs/8.0/static/transaction-iso.html
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;
Ali Baba [EMAIL PROTECTED] writes:
exception
when others then
raise info 'error generated ';
commit;
RETURN 0;
end;
You can't COMMIT inside a function.
-Doug
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
[This question would probably be more appropriate in pgsql-general
than in pgsql-hackers.]
On Wed, Aug 17, 2005 at 05:53:14AM -0700, Ali Baba wrote:
can any one describe how the transaction are being
handled in postgres.
I think you're talking about how PL/pgSQL exception handlers work
with
Ali Baba wrote:
can any one describe how the transaction are being
handled in postgres.
Pretty much the same as in any other SQL implementation, and you'd have
the same problem in any database. Is this a homework assignment?
Jeroen
---(end of