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

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.

> 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