postgresql-jdbc.git / summary / log / commit / refs

commit    4cae52b3a236ef8b6a63ce6fa76a5f3238fc51ea
Author:   Kris Jurka <books@ejurka.com>
Date:     Sun Oct 10 17:28:21 2004 +0000

    For updateable ResultSets make insertRow and deleteRow quote column
    names like updateRow already does.  This makes these methods work
    on mixed case identifiers.


 org/postgresql/jdbc2/AbstractJdbc2ResultSet.java | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java b/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
index ee3ea9d3..d6554e18 100644
--- a/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
+++ b/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
@@ -680,7 +680,9 @@ public abstract class AbstractJdbc2ResultSet implements BaseResultSet, org.postg
 
 			for ( int i = 0; i < numKeys; i++ )
 			{
-				deleteSQL.append( ((PrimaryKey) primaryKeys.get(i)).name ).append( " = ? " );
+				deleteSQL.append("\"");
+				deleteSQL.append( ((PrimaryKey) primaryKeys.get(i)).name );
+				deleteSQL.append("\" = ?");
 				if ( i < numKeys - 1 )
 				{
 					deleteSQL.append( " and " );
@@ -731,7 +733,9 @@ public abstract class AbstractJdbc2ResultSet implements BaseResultSet, org.postg
 			{
 				String columnName = (String) columnNames.nextElement();
 
+				insertSQL.append("\"");
 				insertSQL.append( columnName );
+				insertSQL.append("\"");
 				if ( i < numColumns - 1 )
 				{
 					insertSQL.append(", ");


[parent: a60e653e99c2]