Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Date
Msg-id 41477610.8070202@opencloud.com
Whole thread Raw
In response to Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION  (Kris Jurka <books@ejurka.com>)
Responses Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION  (Kris Jurka <books@ejurka.com>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Problem with dollar-quoted CREATE OR REPLACE FUNCTION
Next
From: Kris Jurka
Date:
Subject: Re: Customizing SSL with jdbc