Re: Finding error in long input file
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2024-07-09T22:46:54Z
Lists: pgsql-general
On Tue, 9 Jul 2024, Rich Shepard wrote: > Should I run BEGIN: at the psql prompt prior to entering the insert > command? Would that tell me if any rows were entered and, if so, where > that stopped? Began a transction, ran the script, checked the locations table for a couple of rows to be inserted. They weren't. Issued the rollback; command. How best should I proceed to isolate the source of the error at the end of the file? Rich