Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group