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 the xyz--1.0.sql file and its definition in the xyz.c file. Now I want to drop this function in the next upgrade i.e. xyz--1.0--1.1 so I will use DROP FUNCTION fun(); in it and remove the definition from the xyz.c file. Here my doubt is wouldn't xyz--1.0 complain about the missing definition of fun() and if yes how can I clean up my function definition in the xyz.c file?
I had earlier asked the same question in DBS StackExchange but didn't get any reply hence trying my luck here.