Re: Multi-row insert: error at terminal row. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Multi-row insert: error at terminal row.
Date
Msg-id 5316a4fa-0fa9-a56f-0f30-14edb10828e8@aklaver.com
Whole thread Raw
In response to Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 10/29/20 9:59 AM, Rich Shepard wrote:
> On Thu, 29 Oct 2020, Adrian Klaver wrote:
> 
>> INSERT INTO products (product_no, name, price) VALUES
>>    (
>>    (1, 'Cheese', 9.99),
>>    (2, 'Bread', 1.99),
>>    (3, 'Milk', 2.99)
>> );
>>
>> then you should have gotten a different error. Something like:
>>
>> ERROR:  column "product_no" is of type integer but expression is of 
>> type record
> 
> Adrian,
> 
> Tried that but the error was the same: the closing semi-colon.

It should not have been the same, so there is something else amiss.

> 
>> I'm going to say the issue is more like what David posted, an escaping
>> problem in the data. Not sure how many rows you are dealing with, but it
>> might be helpful to break them down into smaller batches to isolate the
>> problem.
> 
> Yep, that's what I'll do.
> 
> Thanks,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Multi-row insert: error at terminal row.
Next
From: Rich Shepard
Date:
Subject: Re: Multi-row insert: error at terminal row. [RESOLVED]