Jasid ZA wrote:
> Hi,
>
> Can we use sql transaction(BEGIN, COMMIT, REVOKE) inside a user defined
> function in Postgresql 8.3?
Would that part of the documentation help?
http://www.postgresql.org/docs/8.3/interactive/plpgsql-structure.html
"Functions and trigger procedures are always executed within a
transaction established by an outer query — they cannot start or commit
that transaction, since there would be no context for them to execute in."
so in short: no.
Regards
Tino