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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Multi-row insert: error at terminal row.
Дата
Msg-id CAKFQuwasu2tSe96=ngfnVoS5+JHxZDC7ZTYpAoQcoSmASvQNgg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Thu, 29 Oct 2020, David G. Johnston wrote:

> That said seeing the first few rows, in addition to the last few, would
> help.

David,

insert into organizations (org_nbr,org_name,org_url,org_email,industry,status,comment) values
(1,'Tidewater Contractors Inc',null,null,'Mining','Opportunity','GEN12A'),
(2,'All Rock LLC','www.allrockllc.com',null,'Mining','Opportunity','GEN12A'),
...


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 J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Multi-row insert: error at terminal row.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Multi-row insert: error at terminal row.