Applied patch for bug #741

gsherman · gsherman · commit 6f184257bd51 · 2007-11-16T23:38:36.000Z
Please test git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@7431 c8812cc2-4d05-0410-92ff-de0c093fc19c
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -541,7 +541,7 @@ void QgsPostgresProvider::select(QgsAttributeList fetchAttributes,
     {
       if( (*it) != primaryKey) //no need to fetch primary key again
 	{
-	  declare += "," + *it + "::text";
+	  declare += ",\"" + *it + "\"";
 	}
     }
 
@@ -635,7 +635,7 @@ bool QgsPostgresProvider::getFeatureAtId(int featureId,
   {
     if( (*namesIt) != primaryKey) //no need to fetch primary key again
       {
-	sql += "," + *namesIt + "::text";
+	sql += ",\"" + *namesIt + "\"";
       }
   }
 

Original file line number	Diff line number	Diff line change
`@@ -541,7 +541,7 @@ void QgsPostgresProvider::select(QgsAttributeList fetchAttributes,`
`541`	`541`	`{`
`542`	`542`	`if( (*it) != primaryKey) //no need to fetch primary key again`
`543`	`543`	`{`
`544`		`- declare += "," + *it + "::text";`
	`544`	`+ declare += ",\"" + *it + "\"";`
`545`	`545`	`}`
`546`	`546`	`}`
`547`	`547`
`@@ -635,7 +635,7 @@ bool QgsPostgresProvider::getFeatureAtId(int featureId,`
`635`	`635`	`{`
`636`	`636`	`if( (*namesIt) != primaryKey) //no need to fetch primary key again`
`637`	`637`	`{`
`638`		`- sql += "," + *namesIt + "::text";`
	`638`	`+ sql += ",\"" + *namesIt + "\"";`
`639`	`639`	`}`
`640`	`640`	`}`
`641`	`641`