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

From David G. Johnston
Subject Re: Multi-row insert: error at terminal row.
Date
Msg-id CAKFQuwa_SSVT0ON68jAp83ZJd7SKbXYvVbB1=-C5ThLpyM=7_Q@mail.gmail.com
Whole thread Raw
In response to Re: Multi-row insert: error at terminal row.  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: Multi-row insert: error at terminal row.  (Paul Förster <paul.foerster@gmail.com>)
Re: Multi-row insert: error at terminal row.  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Thu, Oct 29, 2020 at 9:16 AM Paul Förster <paul.foerster@gmail.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.

pgsql-general by date:

Previous
From: Paul Förster
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]