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

On Thu, Oct 29, 2020 at 9:16 AM Paul Förster <paul(dot)foerster(at)gmail(dot)com>
wrote:

> But I guess that Emacs shows the matching closing bracket at the beginning
> of the line, which matches that single tuple. But you also need a closing
> bracket for the set of tuples like this:
>
> insert ...
> (
> (v1, v2, v3),
> (v4, v5, v6),
> (v7, v8, v9) <= this is the bracket pair that Emacs shows as
> matching.
> ); <= this is the missing bracket.
>
>
Except that isn't valid INSERT statement syntax. You are missing "values"
and there is no enclosing parens:

INSERT INTO tbl (i) VALUES (1), (2), (3); --this is perfectly valid

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

David J.