On Wed, 19 Jun 2024, Ron Johnson wrote:
The problem is that you don't know where it's failing.
Ron, True that. There's no specificity to why the transaction didn't complete.
I suggest you run "\echo all" before running "\i insert-law-offices-addr.sql". That way, you'll see which line it barfs on.
Good point. I'll do that. In the meantime, commenting out (or removing) the BEGIN; command inserts all rows without error. Regards, Rich