Re: [SQL] Is function atomic?

[Richard Huxton]

From: "Wei Weng" <[EMAIL PROTECTED]>

> If it is not, is it possible to acquire a lock on a row ? how about a
> lock on a table?

All functions take place within a transaction, but since PG doesn't support
nested transactions yet you can't roll back the effects of a nested
function.

- Richard Huxton


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl