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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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