Problem with dollar-quoted CREATE OR REPLACE FUNCTION

From: Tim Penhey <tim(at)penhey(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Date: 2004-09-14 14:30:33
Message-ID: 41470089.8010207@penhey.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi All,

I am currently using the beta 2 dev 3 binary for 8.0 on WinXP.
I am using the pgdev.305.jdbc3.jar and eclipse for Java dev.

I have a CREATE OR REPLACE FUNCTION that uses $BODY$ to start and finish
the body of the function.
When submitting that through jdbc it complains:

ERROR: unterminated dollar-quoted string at or near "$BODY$ LANGUAGE
'plpgsql'"

If I copy and paste that create function statement and paste it in
pgAdmin, it works fine.

Any ideas?

Tim

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-09-14 14:38:02 Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Previous Message Kris Jurka 2004-09-14 10:41:39 Re: Problem with postgres and Suse