Horton
Menu

Re: How to perform a long running dry run transaction without blocking

Rob Sargent <robjsargent@gmail.com>

View thread
From: Rob Sargent <robjsargent@gmail.com>
To: Robert Leach <rleach@princeton.edu>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2025-02-06T18:53:38Z
Lists: pgsql-general 
> 
Have you considered a validation app? Have it read the inputs and look in db for conflicts, rather than attempt the insert. Zero transactions necessary