Re: proposal - get_extension_version function - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal - get_extension_version function
Date
Msg-id CAFj8pRD1zK4BverBPmOt-mUBpJQ1WNMK+a-5pU_ZER1JUYUOJQ@mail.gmail.com
Whole thread Raw
In response to proposal - get_extension_version function  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hi


st 8. 3. 2023 v 17:58 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
Hi

I try to write a safeguard check that ensures the expected extension version for an extension library.

Some like

const char *expected_extversion = "2.5";

...

extoid = getExtensionOfObject(ProcedureRelationId, fcinfo->flinfo->fn_oid));
extversion = get_extension_version(extoid);
if (strcmp(expected_extversion, extversion) != 0)
   elog(ERROR, "extension \"%s\" needs \"ALTER EXTENSION %s UPDATE\",
          get_extension_name(extversion),
          get_extension_name(extversion)))

Currently the extension version is not simply readable - I need to read directly from the table.

Notes, comments?

attached patch

Regards

Pavel
 

Regards

Pavel

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: cpluspluscheck vs ICU
Next
From: Andres Freund
Date:
Subject: Re: Dead code in ps_status.c