search

xataio / pgroll

PostgreSQL zero-downtime migrations made easy
https://www.xata.io
Apache License 2.0
2.97k stars 54 forks source link

Inferred migrations should distinguish by timestamp between statements executed in a single transaction #361

Closed andrew-farries closed 2 months ago

andrew-farries commented 2 months ago

Statements executed in a single transaction result in two inferred migrations in the pgroll.migrations table with the same timestamp.

Though the use of statement_timestamp it should be possible to have such inferred migrations recorded with different timestamps that reflects their order of execution within the transaction.