From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: Nested Sets
Date: Sat, 16 Apr 2005 17:34:28 -0400
Message-ID: <m31x9a2yor.fsf@knuth.cbbrowne.com> (raw)
References: <fc63e1af0504160531795a314d@mail.gmail.com>
<pan.2005.04.16.13.04.47.372088@arvin.dk>
<fc63e1af05041607286c0447e8@mail.gmail.com>
<20050416181457.GA14377@phlogiston.dyndns.org>
<pan.2005.04.16.20.02.24.212579@arvin.dk>
After takin a swig o' Arrakan spice grog, troels@arvin.dk (Troels Arvin) belched out:
> On Sat, 16 Apr 2005 14:14:57 -0400, Andrew Sullivan wrote:
>> You shouldn't need to do anything special around table
>> locking.
>
> - Except of one wants "True Serializability" (see chapter 12.2 in the
> manual). But I don't know if it's possible to handle table locking from
> within a user defined function.
"Inside stored functions" is one of the ultimate examples of places
where you are certain to be honest-to-goodness inside a transaction.
You can't change transactions while inside a function; all the
in-the-function processing is sure to take place in one transaction's
context.
In theory, savepoints may ultimately change that a little bit, in that
you might have portions of processing in different subtransactions.
But nonetheless Andrew's point remains valid: There is no need to do
any special locking surrounding processing that goes on inside a
stored procedure because it is all suitably embedded in a transaction.
--
(reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc"))
http://linuxdatabases.info/info/slony.html
"The problem with the current Lisp Machine system is that nothing ever
calls anything anymore." -- KMP
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Nested Sets
In-Reply-To: <m31x9a2yor.fsf@knuth.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox