ERROR: stack depth limit exceeded

Поиск
Список
Период
Сортировка
От gzh
Тема ERROR: stack depth limit exceeded
Дата
Msg-id 1e6b9056.492e.18a6e9a1798.Coremail.gzhcoder@126.com
обсуждение исходный текст
Ответы Re: ERROR: stack depth limit exceeded
Re: ERROR: stack depth limit exceeded
Список pgsql-general

Hi, 


I upgraded the version of PostgreSQL from 12.13 to 12.16. 

If multiple subqueries or a large number of UNION ALL were used, 

the previously unseen error message "ERROR: stack depth limit exceeded" will appear after upgrading the version.


I understand that increasing the value of max_stack_depth can prevent code errors, 

but is there a good way to find out which SQL statements have issues without having to run all SQL statements, as it would be too expensive?


Regards


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