From: Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
To: Richard <blackw@sfu.ca>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Bug in parser?
Date: Mon, 7 Feb 2000 11:17:59 -0600
Message-ID: <20000207111759.D24062@rice.edu> (raw)
In-Reply-To: <389EF2A7.565769D0@sfu.ca>
References: <389B70B7.D428C352@sfu.ca>
<389B88ED.DF613747@austin.rr.com>
<389EF2A7.565769D0@sfu.ca>
Richard -
I recently tripped over some whitespace sensitivity (that shouldn't be
there!) involving line-endings in queries. Could you try your UPDATE all
on one line, and see if that solves it? I haven't been able to replicate
my problem with my current set up (in order to file a bug report). It
originally happened with a demo system we had set up at a meeting. Once
we got back to the office, everything worked fine, of course!
We got the same sort of 'paser error at or near ""' line in the log,
but when I looked with the right editor, I say that there was a control
character (either ^M or ^R, can't remember which) between the quotes.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Mon, Feb 07, 2000 at 08:28:23AM -0800, Richard wrote:
> Thanks, but nope... didn't help.
>
> Cheers,
> Richard
>
> Ed Loehr wrote:
> >
> > Richard wrote:
> > >
> > > UPDATE ActiveUser SET status=-1
> > > WHERE (datetime('today'::date, 'now'::time) - lastrequest) >
> > > timespan('10 minutes'::reltime)
> > >
> > > parser: parser error at or near ""
> > >
> > A guess: try spaces around your '=' operator...that one sometimes
> > doesn't like being crowded...
> >
> > Cheers,
> > Ed Loehr
>
> ************
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@wallace.ece.rice.edu, blackw@sfu.ca
Subject: Re: [INTERFACES] Bug in parser?
In-Reply-To: <20000207111759.D24062@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox