Re: recursive SQL functions

Поиск
Список
Период
Сортировка
От Don Baccus
Тема Re: recursive SQL functions
Дата
Msg-id 3C1E5E0B.6090308@pacifier.com
обсуждение исходный текст
Ответ на recursive SQL functions  (Don Baccus <dhogaza@pacifier.com>)
Ответы Re: recursive SQL functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Explicit config patch 7.2B4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: recursive SQL functions