Re: Finding error in long input file

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Finding error in long input file
Date: 2024-07-09 22:46:54
Message-ID: 53c9d6fa-8992-2a69-471e-7df37e594991@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-07-09 22:52:54 Re: Finding error in long input file
Previous Message Rich Shepard 2024-07-09 22:40:33 Re: Finding error in long input file