http://www.postgresql.org/docs/7.2/interactive/plpgsql-structure.html
"It is important not to confuse the use of BEGIN/END for grouping statements in
PL/pgSQL with the database commands for transaction control. PL/pgSQL's BEGIN/END are
only for grouping; they do not start or end a transaction. F
After takin a swig o' Arrakan spice grog, Cris Carampa <[EMAIL PROTECTED]> belched
out...:
> 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
> au
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?
