Postgres Pro
Downloads
Home   >   mailing lists

Re: Is function atomic? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Is function atomic?
Date
Msg-id 003601c1063a$ea739e00$1001a8c0@archonet.com
Whole thread Raw
In response to Is function atomic?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
From: "Wei Weng" <wweng@kencast.com>

> 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

pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Re: Is function atomic?
Next
From: Wei Weng
Date:
Subject: Re: Is function atomic?