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

2025-05-07 Thread Agis
On Wed, May 7, 2025, 00:57 Laurenz Albe wrote: > On Tue, 2025-05-06 at 12:06 +0300, Agis Anastasopoulos wrote: > > 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. >

Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Agis Anastasopoulos
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. The general idea is: - you have a test database that'