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
