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

From: "B(dot) Jordan" <bujordan(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Date: 2007-05-04 16:07:48
Message-ID: d7c16fe80705040907s45391a34p64b595f62531f078@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-05-04 16:16:00 Re: connection variables problem
Previous Message Badawy, Mohamed 2007-05-02 12:08:29 connection variables problem