Method TryGenerateKeysInAmbientTransactionAsync(int)
Inside a TransactionScope a refill on a connection of its own would be a second connection in the
transaction, which PostgreSQL can only commit as a prepared (two-phase) transaction. The values are
taken through the scope's wrapper instead - on the transaction's connection. nextval is not
transactional: a rollback leaves a gap, never a duplicate.
protected override Task<List<long>?> TryGenerateKeysInAmbientTransactionAsync(int count)