transaction management in plpgsql functions

From: Cris Carampa <cris119(at)operamail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: transaction management in plpgsql functions
Date: 2003-11-06 09:24:56
Message-ID: bod454$e2o$1@panco.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

It seems that transaction management statements (begin work...commit
work) are not allowed into plpgsql functions. Is it true? If true, what
happens if I put a DML statement into a function? Is it automatically
commited every time the function executes? Is there no way to rollback
the changes?

Kind regards,

--
Cris Carampa (spamto:cris119(at)operamail(dot)com)

"Poveri fanatici comunisti, noglobal e affetti dalla sindrome
anti-microsoft" (gli utenti Linux secondo un poster di ICOD)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-11-06 17:52:00 Re: [HACKERS] What's wrong with this group by clause?
Previous Message Jerome Alet 2003-11-06 06:18:07 Re: avoid circular references