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@xxxxxxxxxxx
