On Thu, 2023-10-12 at 19:56 +0300, Nikita Malakhov wrote:
> Say, we have data processed by some user function and we want to keep reference to this function
> in our data. In this case we have two ways - first - store string output of regprocedure, which is not
> very convenient, and the second - store its OID, which requires slight modification of pg_upgrade
> (pg_dump and func/procedure creation function).
So far, we have lived quite well with the rule "don't store any system OIDs in the database
if you want to pg_upgrade" (views on system objects, reg* data types, ...).
What is inconvenient about storing the output of regprocedure?
Yours,
Laurenz Albe