Re: Fresh eyeballs needed: input into error

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