Bugs: Browse | Submit New | Admin

[#24564] "INSERT INTO ... RETURNING" fails with "A result was returned when none was expected."

Date:
2009-03-15 13:26		 Priority:
3
Submitted By:
Xuân Baldauf (mediumnet) 		Assigned To:
Nobody (None)
Category:
None		 State:
Open
Summary:
"INSERT INTO ... RETURNING" fails with "A result was returned when none was expected."

Detailed description 
After fixing postgresql_version, jdbc_postgre.rb switches to using the "INSERT INTO ... RETURNING" syntax
(which is correct, because the alternative way of obtaining the primary key value (querying the current sequence number)
is not atomic). However, it looks like JDBC does not expect INSERT to return a table.

Add A Comment: Notepad

Please login


Followup

Message 
Date: 2009-03-15 20:50
Sender: Nick Sieger

Hi, we no longer use this tracker to track bugs here. Can you
please file a copy of this bug at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC ?

Thanks!

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

Field Old Value Date By
summary"INSERT INTO ... RETURNING" fails with "A result was returned when none was expected."2009-03-15 20:50nicksieger