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

Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tim Penhey <tim(at)penhey(dot)net>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Date: 2004-09-14 14:38:02
Message-ID: 1095172682.1549.65.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
Can you show us the code, logs?

Dave
On Tue, 2004-09-14 at 10:30, Tim Penhey wrote:
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
-- 
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com


In response to

Responses

pgsql-jdbc by date

Next:From: Tim PenheyDate: 2004-09-14 14:55:56
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Previous:From: Tim PenheyDate: 2004-09-14 14:30:33
Subject: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

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