Re: Parser: parse error - please help... - Mailing list pgsql-general

From Richard Poole
Subject Re: Parser: parse error - please help...
Date
Msg-id 20031223084604.GA8404@guests.deus.net
Whole thread Raw
In response to Parser: parse error - please help...  (Andrew Ayers <aayers@eldocomp.com>)
List pgsql-general
On Mon, Dec 22, 2003 at 04:24:52PM -0700, Andrew Ayers wrote:

> DEFAULT, DEFAULT, 'Test', 'Tester', 'http:\\www.eldocomp.com\', DEFAULT,
> false, DEFAULT, '09/11/2002', DEFAULT, DEFAULT, '09/11/2002', DEFAULT,

The \ at the end off the URL in the first line here is escaping the '
after it, so the string which should consist of just the URL is being
taken to include everything up to the next ' , the one at the beginning
of the date. Then the date itself appears to fall outside quotes, hence
Pg tries to parse it, hence parse error at 09.

The \ in the URL should be / - this goes for all \ in all URL.

Richard

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Solved: questions about tsearch2 (for czech language)
Next
From: "John Sidney-Woollett"
Date:
Subject: Re: Normalization and regexp