Re: One question about callablestatement - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: One question about callablestatement
Date
Msg-id n7obcm$3fc$1@ger.gmane.org
Whole thread Raw
In response to One question about callablestatement  (张元超 <zhangyuanchao@highgo.com>)
List pgsql-jdbc
张元超 schrieb am 20.01.2016 um 03:14:
> Hi,
>      Now ,i found one question about callablestatement.if i have a function whoes name containts '}',
>and i call it by callablestatement,there will be a 'PSQLException'. Like this:
>
> The function name i used is "test_fu}n2".Yeah,i kown that may be nobody will create a function with some
>name like this,but, it can be created successfully.Ok, i check the code of jdbc,i found some problem lead to
>the question above. The code file is org/postgresql/core/Parser.java,and row 603 to row 646,the handle of '}' .
>


You don't need a CallableStatement to call a function in Postgres.

What happens if you use a regular Statement and executeQuery("select \"test_fu}n2\"");




pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Step towards being able to build on Linux (Pull request #435)
Next
From: Pavel Raiskup
Date:
Subject: Re: Step towards being able to build on Linux (Pull request #435)