Re: Deploy modifications of database objects - Mailing list pgsql-admin
You could use different schemas, but that seems like overkill to me.
What I would do, is make sure the function code is backwards compatible, and just replace. Or alternatively, you could have a master function run child functions depending on what version you need.
On Tue, Jun 22, 2021 at 9:00 AM Mai Peng <maily.peng@webedia-group.com> wrote:
Hello everyone,
We often deploy modified function code to production database. In order to impact the less users that still use the old version of these functions, we add another function. I think it’s not relevant.
How could we deploy these modifications ? Add a schema per version ?
Thank you in advance.
Mai
Jayson Hreczuck | Principal Database Administrator
C: +1 617.571.9861
130 Turner St, Ste 530, Waltham, MA 02453pgsql-admin by date: