Recursive plpgsql function in rule

Поиск
Список
Период
Сортировка
От mito
Тема Recursive plpgsql function in rule
Дата
Msg-id gsf0no$1e8p$1@news.hub.org
обсуждение исходный текст
Ответы Re: Recursive plpgsql function in rule  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
I am trying to select subtree by parent id in table:

create table categories(id int,parent_id int
);

I am fetching it by recursive plpgsql function, which works well.

When i use that function as part of rule operation, i am getting ERROR:  stack depth limit exceeded.

I have tried to rewrite without recursion which cause infinite loop in rule.

Is it possible to sent dynamic structures in planer?
Or how to fetch subtree without change of table structure inside rule?

Thanks


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE
Следующее
От: mito
Дата:
Сообщение: Reference on partial data