From: | Richard <blackw(at)sfu(dot)ca> |
---|---|
To: | |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] Bug in parser? |
Date: | 2000-02-07 17:59:06 |
Message-ID: | 389F07EA.6F39E687@sfu.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Bingo!
I erased the SQL command and typed it on one line. Works find. Broke
it up again with linefeeds. STILL WORKS!
Now I wish I had commented-out the original command rather than
replacing it, as now I don't know what the rogue character was!
Grrrrrr! (I need more sleep!)
Thanks for your help. And thanks to Axel too, who e-mailed me directly
suggesting the same thing.
Cheers,
Richard
"Ross J. Reedstrom" wrote:
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2000-02-07 18:46:03 | Re: [INTERFACES] Bug in parser? |
Previous Message | Ross J. Reedstrom | 2000-02-07 17:17:59 | Re: [INTERFACES] Bug in parser? |