On Wed, 27 Apr 2022, Francisco Olarte wrote:
Where you using cut&paste / selection or something similar? Lately I've
been getting weird errors on paste operations due to bracketed paste,
which are puzzling, It seems to have interactions with readline and other
stuff depending on where the cursor
Rich:
On Wed, 27 Apr 2022 at 14:38, Rich Shepard wrote:
> On Tue, 26 Apr 2022, Bruce Momjian wrote:
> > I am curious what OS psql was using that was fixed by a re-login?
> This desktop's running Slackware64-14.2.
Where you using cut&paste / selection or something similar? Lately
I've been gettin
On Wed, 27 Apr 2022, Rob Sargent wrote:
Have you tried \r instead of C-c?
Rob,
No, I haven't. I'll try it to reset the query buffer the next time I make a
mistake entering a command.
Thanks,
Rich
> On Apr 27, 2022, at 5:43 AM, Rich Shepard wrote:
>
> On Wed, 27 Apr 2022, Laurenz Albe wrote:
>
>
> From time to time I mis-type a character or make another error and psql
> responds with a different prompt and no explicit explanation. I'll then type
> C-c and get the default => prompt ba
On Wed, 27 Apr 2022, Laurenz Albe wrote:
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 e
On Tue, 26 Apr 2022, Bruce Momjian wrote:
I am curious what OS psql was using that was fixed by a re-login?
Bruce,
This desktop's running Slackware64-14.2.
Regards,
Rich
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_
On 4/26/22 20:11, Bruce Momjian wrote:
On Tue, Apr 26, 2022 at 06:09:42PM -0700, Rich Shepard wrote:
On Tue, 26 Apr 2022, Rich Shepard wrote:
I am curious what OS psql was using that was fixed by a re-login?
Rich uses Slackware.
--
Adrian Klaver
adrian.kla...@aklaver.com
On Tue, Apr 26, 2022 at 06:09:42PM -0700, Rich Shepard wrote:
> On Tue, 26 Apr 2022, Rich Shepard wrote:
>
> > It's probably a transient glitch that will go away after I log out.
>
> Yep. I logged out and back in just now. The insert script worked as it
> always had before and both rows were adde
On Tue, 26 Apr 2022, Rich Shepard wrote:
It's probably a transient glitch that will go away after I log out.
Yep. I logged out and back in just now. The insert script worked as it
always had before and both rows were added to the table.
I've seen these sort of hang-ups before and didn't want
On 4/26/22 3:08 PM, Rich Shepard wrote:
On Tue, 26 Apr 2022, David G. Johnston wrote:
What version of PostgreSQL?
David,
12.7
Testing on HEAD (and by inspection) nothing you've shown us provokes a
syntax error in PostgreSQL.
regression=> insert into people
(person_nbr,lname,fname,job_titl
On Tue, 26 Apr 2022, Tom Lane wrote:
so there's nothing wrong with the syntax as-presented. I agree with
Adrian's guess about invisible characters in your input file; perhaps a
control-D or ASCII NUL would produce that symptom.
tom,
It's probably a transient glitch that will go away after I l
On Tue, 26 Apr 2022, David G. Johnston wrote:
What version of PostgreSQL?
David,
12.7
Testing on HEAD (and by inspection) nothing you've shown us provokes a
syntax error in PostgreSQL.
regression=> insert into people
(person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
regression(>
loc_p
On 4/26/22 2:53 PM, Rich Shepard wrote:
On Tue, 26 Apr 2022, Adrian Klaver wrote:
I'm guessing some sort of hidden character.
Adrian,
Oh, ... forgot to mention in my response that the MWE values were added to
the template in emacs while I get the same error using psql -d
-f
in a v.t. or
Rich Shepard writes:
> 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
On Tue, Apr 26, 2022 at 2:54 PM Rich Shepard
wrote:
> On Tue, 26 Apr 2022, Adrian Klaver wrote:
>
> > I'm guessing some sort of hidden character.
>
> Adrian,
>
> Oh, ... forgot to mention in my response that the MWE values were added to
> the template in emacs while I get the same error using psq
On Tue, 26 Apr 2022, Adrian Klaver wrote:
I'm guessing some sort of hidden character.
Adrian,
Oh, ... forgot to mention in my response that the MWE values were added to
the template in emacs while I get the same error using psql -d -f
in a v.t. or entering 'insert into people values (...)'
On Tue, 26 Apr 2022, Adrian Klaver wrote:
I'm guessing some sort of hidden character.
Adrian,
The 'insert into ...' string is a template I've been using for years. It's
worked earlier today, too.
What client are you using to run this?
psql in a linux virtual terminal.
Where is the query
On 4/26/22 2:31 PM, 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_e
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,emai
20 matches
Mail list logo
