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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ERROR: stack depth limit exceeded  (Geoff Winkless <pgsqladmin@geoff.dj>)
Список 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 по дате отправления:

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: listening on an address other than 'localhost'?
Следующее
От: David Rowley
Дата:
Сообщение: Re: Query performance going from Oracle to Postgres