Horton

Re: BUG #19034: Recursive function with sql_body can replace an existing function but can not be created on it's own

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "David G. Johnston" <david.g.johnston@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Yushu Chen <gentcys@gmail.com>, katja.henke@foo.ag, PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Date: 2025-09-08T08:31:11Z
Lists: pgsql-bugs 
On Sun, 2025-09-07 at 15:50 -0700, David G. Johnston wrote:
> While I agree making it must work would be nice given the presence of simple
> alternatives to use when this functionality is required it's got to be easier
> to detect and prohibit creation.

Perhaps that is the way to go, although it would not make me happy.
But that still leaves the problem of what to do with a database that
already contains recursive SQL functions during pg_dump/pg_restore.

Yours,
Laurenz Albe