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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Penhey | 2004-09-14 14:55:56 | Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION |
Previous Message | Tim Penhey | 2004-09-14 14:30:33 | Problem with dollar-quoted CREATE OR REPLACE FUNCTION |