From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Fresh eyeballs needed: input into error |
Date: | 2022-04-27 10:49:30 |
Message-ID: | c4f324ca3f194e35ac7c23b467f62d962c4ca7e9.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2022-04-26 at 14:31 -0700, Rich Shepard wrote:
> I'm getting a syntax error with an input into statement and I cannot see the
> cause.
>
> A MWE and the result (N.B.: line one wrapped for readability; it ends with
> 'values'):
> insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
> loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment) values
> (6000,'No','Name',null,404,1,null,null,null,null,null,null,null);
>
> 2: ERROR: syntax error at end of input
> LINE 2: (
> ^
> What do I keep missing?
Another explanation is that there was already something in your query buffer
when you entered that statement, so that together it caused a syntactically
incorrect statement, something like (in psql):
test=> insert
test-> insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment) values
(6000,'No','Name',null,404,1,null,null,null,null,null,null,null);
ERROR: syntax error at or near "insert"
LINE 2: insert into people (person_nbr,lname,fname,job_title,company...
^
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2022-04-27 10:51:11 | Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac |
Previous Message | Alvaro Herrera | 2022-04-27 09:32:07 | Re: "create function... depends on extension..." not supported. Why? |