Re: Soundness of strategy for detecting locks acquired by DDL statements

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.klaver@aklaver.com