On 5/6/25 2:06 AM, Agis Anastasopoulos wrote:
> Hello! I'd like to "preflight" a given schema migration (i.e. one or
> more DDL statements) before applying it to the production database (e.g.
> for use in a CI pipeline). I'm thinking of a strategy and would like to
> know about its soundness.
> Do you think this is a robust way to detect the locks that were
> acquired? Are there any caveats/drawbacks/flaws in this strategy?
Why not just read this?:
https://www.postgresql.org/docs/current/explicit-locking.html
>
> Thanks in advance
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com