Syntax error near returning

["Jonathan Tripathy" <jonnyt@xxxxxxxxxxx>]

Hi Everyone,

When I create a prepared statement like this in java (using JDBC):

pStmt = conn.prepareStatement(qry);

everything works ok. However when I want a scrollable resultset and use this:

pStmt = conn.prepareStatement(qry,ResultSet.TYPE_SCROLL_INSENSITIVE);

I get a syntax error:

org.postgresql.util.PSQLException: ERROR: syntax error at or near "RETURNING"

I'm not even using RETURNING in my query. I think that my issue mayh be related to this post:

http://archives.postgresql.org/pgsql-jdbc/2010-04/msg00060.php

Any ideas?

Any help would be appreciated. Thanks