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
smime.p7s
Description: S/MIME Cryptographic Signature