Re: Query regarding function cleanup in extension upgrade path

2024-02-15 Thread Daniel Gustafsson
> On 14 Feb 2024, at 21:56, Tom Lane wrote: > Ayush Vatsa writes: >> 2. While going through the contrib folder I find that in the regress test >> there are two .out files with respect to a single .sql file, example >> citext.out and citext_1.out wrt citext.sql. Why is it so? Even in git blame >>

Re: Query regarding function cleanup in extension upgrade path

2024-02-14 Thread Tom Lane
Ayush Vatsa writes: > Just two follow up queries regarding this - > 1. Suppose I created a new version 1.1 in which I reduce the C function to > throw an error then ship it, will users get the .c latest file immediately > and their old function will throw error but they have to use ALTER > EXTENSI

Re: Query regarding function cleanup in extension upgrade path

2024-02-14 Thread Ayush Vatsa
Hi Tom thanks for the answer, Just two follow up queries regarding this - 1. Suppose I created a new version 1.1 in which I reduce the C function to throw an error then ship it, will users get the .c latest file immediately and their old function will throw error but they have to use ALTER EXTENSIO

Re: Query regarding function cleanup in extension upgrade path

2024-02-14 Thread Tom Lane
Ayush Vatsa writes: > To ask the question let me give a hypothetical example:- > Suppose we have an extension named xyz with version 1.0. It has > xyz--1.0.sql and xyz.c file. I have declared a function named fun() in the > xyz--1.0.sql file and its definition in the xyz.c file. > Now I want to dr

Query regarding function cleanup in extension upgrade path

2024-02-14 Thread Ayush Vatsa
Hi PostgreSQL Community, I have been working on a few extensions but got confused in the upgrade scenario. To ask the question let me give a hypothetical example:- Suppose we have an extension named xyz with version 1.0. It has xyz--1.0.sql and xyz.c file. I have declared a function named fun() in