Re: [HACKERS] Recursive plpgsql function in rule

2009-04-19 Thread Heikki Linnakangas
mito wrote: 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

[HACKERS] Recursive plpgsql function in rule

2009-04-19 Thread mito
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