Horton
Menu

Re: Stored procedure code no longer stored in v14 and v15, changed behaviour

Christophe Pettus <xof@thebuild.com>

View thread
From: Christophe Pettus <xof@thebuild.com>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston" <david.g.johnston@gmail.com>, "Martijn Tonies (Upscene Productions)" <m.tonies@upscene.com>, pgsql-general@lists.postgresql.org
Date: 2022-12-01T19:08:23Z
Lists: pgsql-general 

> On Dec 1, 2022, at 11:05, Dominique Devienne <ddevienne@gmail.com> wrote:
> 
> I see. Still, Oracle preserves SQL as-is. SQLite preserve SQL as-is.
> Would be nice if PostgreSQL did too. That's all I'm saying.

Since this is a custom-built system, there is nothing keeping you from creating your own table in the database that stores the original text of the function.