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

Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Tim Penhey <tim(at)penhey(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Date: 2004-09-14 22:52:00
Message-ID: 41477610.8070202@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:

> Your options seem to be:
>  - don't use dollar quoting
>  - use the 7.4 driver which doesn't try to split queries
>  - teach the driver about dollar quoting

It's a pity the grammar doesn't let you specify the function body as a 
parameter, then you could just use a PreparedStatement and avoid the 
quoting problems altogether..

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-09-14 23:58:44
Subject: Re: Customizing SSL with jdbc
Previous:From: Kris JurkaDate: 2004-09-14 18:47:03
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION

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