Re: recursive SQL functions - Mailing list pgsql-hackers

From Don Baccus
Subject Re: recursive SQL functions
Date
Msg-id 3C1E5E0B.6090308@pacifier.com
Whole thread Raw
In response to recursive SQL functions  (Don Baccus <dhogaza@pacifier.com>)
Responses Re: recursive SQL functions
List pgsql-hackers
Tom Lane wrote:


> Aside from the forward-reference problem, which seems easy enough to
> solve, I think there may be some performance issues that'd have to be
> dealt with (memory leaks and so forth).

OK, that's reasonable.  If potential memory leaks are only for the 
duration of a transaction I'm not worried (in regard to the one 
recursive function we're using) as it's cachable and our trees not very 
deep.

I have found one bug that crashed the backend if a recursive function's 
called.  Are you interested in it, since folks can now define them 
semi-officially (if a bit unconventially) via CREATE AND REPLACE?

-- 
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Explicit config patch 7.2B4
Next
From: Tom Lane
Date:
Subject: Re: recursive SQL functions