Обсуждение: BUG #8746: While Calling Trigger on same table

Поиск
Список
Период
Сортировка

BUG #8746: While Calling Trigger on same table

От
sahareanish@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      8746
Logged by:          Anish
Email address:      sahareanish@gmail.com
PostgreSQL version: 9.2.4
Operating system:   Window 7
Description:

ERROR:  stack depth limit exceeded
HINT:  Increase the configuration parameter "max_stack_depth" (currently
2048kB), after ensuring the platform's stack depth limit is adequate.

Re: BUG #8746: While Calling Trigger on same table

От
Michael Paquier
Дата:
On Wed, Jan 8, 2014 at 12:54 AM,  <sahareanish@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8746
> Logged by:          Anish
> Email address:      sahareanish@gmail.com
> PostgreSQL version: 9.2.4
> Operating system:   Window 7
> Description:
>
> ERROR:  stack depth limit exceeded
> HINT:  Increase the configuration parameter "max_stack_depth" (currently
> 2048kB), after ensuring the platform's stack depth limit is adequate.
It is rather hard to guess what you are trying to solve here, but it
seems that you have a recursive function running that hit the maximum
execution stack. For your information, here is some documentation:
http://www.postgresql.org/docs/devel/static/runtime-config-resource.html
Regards,
--
Michael