ERROR: stack depth limit exceeded

From: gzh <gzhcoder(at)126(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ERROR: stack depth limit exceeded
Date: 2023-09-07 07:45:06
Message-ID: 1e6b9056.492e.18a6e9a1798.Coremail.gzhcoder@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2023-09-07 10:48:06 Re: Query performance going from Oracle to Postgres
Previous Message Erik Wienhold 2023-09-07 07:23:19 Re: listening on an address other than 'localhost'?