On 12/02/2024 20:31, John English wrote:
On 12/02/2024 20:02, Rick Hillegas wrote:
With that change, the script fails further on with the creation of the
registrations table:
Argh. The owner of this DB asked me to strip it down rather than publish
it in full. Apologies.
In the end I decided to bite the bullet and merge active_list and
current_list into a single table (which wasn't as hard as I had feared).
In the process I realised that the trigger which seems to be the cause
of the deadlock is not actually needed... the situation that it was
created to deal with was fixed about five years ago! So dropping the
trigger would seem to solve the problem.
It's amazing how much crap piles up in old DB schemas -- this one is
close to 20 years old and appears to have been bashed around a lot in
the past by people with quite different ideas of how to do things. And
now it's my turn to bash it some more.
--
John English
