ERROR: stack depth limit exceeded - Mailing list pgsql-general

From gzh
Subject ERROR: stack depth limit exceeded
Date
Msg-id 1e6b9056.492e.18a6e9a1798.Coremail.gzhcoder@126.com
Whole thread Raw
Responses Re: ERROR: stack depth limit exceeded  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ERROR: stack depth limit exceeded  (Geoff Winkless <pgsqladmin@geoff.dj>)
List 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 by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: listening on an address other than 'localhost'?
Next
From: David Rowley
Date:
Subject: Re: Query performance going from Oracle to Postgres