Re: Problem with creating language by JDBC

Ming Deng wrote on 24.06.2010 19:44:
> Hi there,
>
> I was trying to create language by execute() or executeUpdate(). But the
> call always fails with message as
>
> problem running SQL query: CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
>    HANDLER plpgsql_call_handler
> .An I/O error occured while sending to the backend.
>
> Following is a snippet of the Java code I have, which works with
> creating database, executing other queries:
>

Did you try to use a regular statement, instead of a PreparedStatement?

Statement stmt = con.createStatement()
stmt.executeUpdate("CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler");

Thomas