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

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Multi-row insert: error at terminal row.
Date: 2020-10-29 16:58:06
Message-ID: alpine.LNX.2.20.2010290953500.522@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 29 Oct 2020, David G. Johnston wrote:

> As your general syntax seems correct I would suspect an issue in the data
> values - like having a single quote in an organization name that isn't
> properly escaped (doubled). I'd first make sure insert one record works
> then begin bisecting your values, only inserting subsets at a time, until
> you narrow down the offending record.

David,

I checked and repaired all single apostrophe's with doubled apostrophies.
Postgres found other syntax errors (period rather than comma; missing comma)
but didn't reject single quotes as apostrophes within a string. Also, there
are no strings in this table that would have apostrophes.

Thanks,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2020-10-29 16:59:47 Re: Multi-row insert: error at terminal row.
Previous Message Adrian Klaver 2020-10-29 16:45:37 Re: Multi-row insert: error at terminal row.