Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?
Дата
Msg-id 4E4A5344.7040004@dunslane.net
обсуждение исходный текст
Ответ на Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers

On 08/16/2011 04:56 AM, Magnus Hagander wrote:
> On Mon, Aug 15, 2011 at 23:49, Greg Stark<stark@mit.edu>  wrote:
>> On Mon, Aug 15, 2011 at 9:31 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>>> ... and that would be a seriously bad API.  There are not SUSET
>>> restrictions on other resources such as work_mem.  Why do we need
>>> one for this?
>> I think a better analogy would be imposing a maximum number of rows a
>> query can output. That might be a sane thing to have for some
>> circumstances but it's not useful in general.
> Uh. You mean like LIMIT, which we already have?

There is no LIMIT imposed on a query by a server setting, which would be 
the right analogy here.

cheers

andrew


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Anssi Kääriäinen
Дата:
Сообщение: Re: index-only scans
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: WIP: Fast GiST index build