Re: Nested Sets - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Nested Sets
Date
Msg-id 20050416181457.GA14377@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Nested Sets  ("A. Kulikov" <a.kulikov@gmail.com>)
List pgsql-sql
On Sat, Apr 16, 2005 at 06:28:27PM +0400, A. Kulikov wrote:
> btw, do stored procedures (user functions in other words) have to
> implement table locking or be carried out inside a transaction such
> that the nested set indexes remain intact?

They're always in a transaction.  Everything in Postgres is always
inside a transaction (although it might be a transaction of a single
statement).  You shouldn't need to do anything special around table
locking.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun


pgsql-sql by date:

Previous
From: "A. Kulikov"
Date:
Subject: Re: Nested Sets
Next
From: Troels Arvin
Date:
Subject: Re: Nested Sets