Re: Parser: parse error - please help...

Поиск
Список
Период
Сортировка
От Richard Poole
Тема Re: Parser: parse error - please help...
Дата
Msg-id 20031223084604.GA8404@guests.deus.net
обсуждение исходный текст
Ответ на Parser: parse error - please help...  (Andrew Ayers <aayers@eldocomp.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Solved: questions about tsearch2 (for czech language)
Следующее
От: "John Sidney-Woollett"
Дата:
Сообщение: Re: Normalization and regexp