Re: Stored procedure code no longer stored in v14 and v15, changed behaviour - Mailing list pgsql-general

From Pasi Oja-Nisula
Subject Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
Date
Msg-id CAJvus-O9Jm75iHam2AA__4_yrVMoa2pzLrxxb9tQhGqzu7nxUg@mail.gmail.com
Whole thread Raw
In response to Re: Stored procedure code no longer stored in v14 and v15, changed behaviour  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-general
On Fri, 2 Dec 2022 at 15:02, Daniel Gustafsson <daniel@yesql.se> wrote:
> How do you today prove that for other compiled programs in your system?

Good question. I guess I never considered database to be compiled.

How do you debug this kind of system? What if the you suspect that there is
a wrong version of procedure in the system? How can you then find what release
or patch produced the problem if you can't see the actual procedure text
that produced the running version?

I'm not claiming that there isn't benefits in this system. I'm sure it actually
prevents rogue changes for not having the source code readily available. It's
just a big fundamental change to get over if you can't do comparison from
database to version control.

Pasi



pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
Next
From: Dominique Devienne
Date:
Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour