Re: Invoking SQL function while doing CREATE OR REPLACE on it

2023-05-04 Thread Nagendra Mahesh (namahesh)
tiny gap in time after the first transaction commit, before the second transaction could commit was when the function actually ceased to exist. So, the invocations during that time failed. Thanks again. From: Erik Wienhold Sent: Thursday, May 4, 2023 2:33 AM To: Nagendra Mahesh (namahesh

Invoking SQL function while doing CREATE OR REPLACE on it

2023-05-03 Thread Nagendra Mahesh (namahesh)
I have a Postgres 14.4 cluster (AWS Aurora) to which I connect from my application using JDBC. I use liquibase for schema management - not only tables, but also a bunch of SQL stored procedures and functions. Basically, there is one liquibase changeSet that runs last and executes a set of SQL f