On Jun 24, 5:38 pm, spam_eater@gmx.net (Thomas Kellerer) wrote:
> 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
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-jdbc
I just tried with the regular statement, got the same failure.