Re: Stack Depth
От | Bob Pawley |
---|---|
Тема | Re: Stack Depth |
Дата | |
Msg-id | 014501c62794$9aad0070$ac1d4318@owner обсуждение исходный текст |
Ответ на | Stack Depth (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Stack Depth
|
Список | pgsql-general |
Thanks all I do think I have a recursive problem. It's just hard to see at the moment. Bob ----- Original Message ----- From: "Michael Fuhr" <mike@fuhr.org> To: "Bricklen Anderson" <banderson@presinet.com> Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Postgresql" <pgsql-general@postgresql.org> Sent: Wednesday, February 01, 2006 4:52 PM Subject: Re: [GENERAL] Stack Depth > On Wed, Feb 01, 2006 at 03:48:38PM -0800, Bricklen Anderson wrote: >> Bob Pawley wrote: >> >I understand the default stack depth is about 2 meg. How do I determine >> >what the stack depth should be so that I avoid this error? >> >> check max_stack_depth in your postgresql.conf file > > Before mucking with max_stack_depth, investigate whether the triggers > are causing infinite recursion (an insert fires a trigger, which > does an insert, which fires a trigger, which does an insert, ad > infinitum). If that's happening then increasing the stack depth > will merely prolong the agony. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: