Syntax error near returning

From: "Jonathan Tripathy" <jonnyt(at)abpni(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Syntax error near returning
Date: 2010-11-23 17:44:32
Message-ID: 46C13AA90DB8844DAB79680243857F0F0AFF30@server1.ABPNI.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Walden 2010-11-23 18:00:55 Re: postmaster.pid does not exist. cannot start postgres server on ubuntu
Previous Message Tom Lane 2010-11-23 17:21:28 Re: Discerning user vs trigger based updates