Re: Multi-row insert: error at terminal row.

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Multi-row insert: error at terminal row.
Date: 2020-10-29 16:04:32
Message-ID: 6FE34808-28CE-4550-9BC4-A70D91503D2C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Rich,

> On 29. Oct, 2020, at 16:58, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
>
> On Thu, 29 Oct 2020, Rob Sargent wrote:
>
>> Can we see the last two line of the file (1924, 1925)?
>
> Rob,
>
> (2697,'Port of Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
> (2698,'Port of Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
>
> Each line is enclosed in parentheses and is terminated with a comma.

the last line has a closing parenthesis missing.

Cheers,
Paul

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2020-10-29 16:08:30 Re: Multi-row insert: error at terminal row.
Previous Message Rich Shepard 2020-10-29 15:58:19 Re: Multi-row insert: error at terminal row.