Re: Multi-row insert: error at terminal row. [RESOLVED]

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Multi-row insert: error at terminal row. [RESOLVED]
Date: 2020-10-29 17:54:26
Message-ID: 2654c9b4-ef5e-3760-a258-447fe1e640ca@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/29/20 10:52 AM, Rich Shepard wrote:
> On Thu, 29 Oct 2020, Adrian Klaver wrote:
>
>> Is orgs-1.sql just the INSERT?
>
> Yes.

Is it just the 50 line version?

If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?

>
>> How is that file being fed to psql?
>
> $ psql -d bustrac -f orgs-1.sql
>
> Rich
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Atul Kumar 2020-10-29 17:59:51 psql asks for password despite configuring trust authentication
Previous Message Rich Shepard 2020-10-29 17:52:03 Re: Multi-row insert: error at terminal row. [RESOLVED]