error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?

Поиск
Список
Период
Сортировка
От B. Jordan
Тема error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Дата
Msg-id d7c16fe80705040907s45391a34p64b595f62531f078@mail.gmail.com
обсуждение исходный текст
Ответы Re: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Список pgsql-jdbc
After digging through the archives and looking at the changelog for
8.2-505 and 8.2-504, it seems that $$ should work, but I'm still
getting errors.

Here's the error message:
Caused by: org.postgresql.util.PSQLException: ERROR: unterminated
dollar-quoted string at or near "$BODY$ BEGIN DELETE FROM ..."

Here's the procedure I'm trying to create (slightly altered for NDA reasons)

CREATE FUNCTION schema.table( del_id INTEGER )
    RETURNS BOOLEAN AS
$BODY$
BEGIN
    DELETE FROM schema.table
        WHERE id = del_id;
    RETURN TRUE;
END
$BODY$
LANGUAGE plpgsql;

Any particular reason I shouldn't be able to execute that with the
latest version (8.2-505) of the driver? I had thought $ quotes were
fixed
(from the changelog: )
"Add support for parsing dollar quotes and comments. (jurka) Thanks to
Michael Paesold".

Any help/suggestions appreciated.

Thanks,

Bucky

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Badawy, Mohamed"
Дата:
Сообщение: connection variables problem
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: connection variables problem