basic stored proc/transaction question

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: basic stored proc/transaction question
Date: 2006-03-24 17:36:38
Message-ID: Pine.LNX.4.64.0603240932140.15001@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My understanding is that a stored procedure does an implicit begin/commit when
it executes. Maybe my brain isn't working so well this morning, because I can't
figure out how I would do:

begin;
call stored proc;
call another stored proc;
commit;

It seems that the transaction would be committed after the first call.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Just Someone 2006-03-24 17:44:42 Re: Practical limit on number of tables ina single database
Previous Message Adrian Klaver 2006-03-24 17:34:10 Re: pgadmin