From f9d2121bcf783e6fd1ad519eff57a287bc43598c Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Tue, 13 Jan 2015 21:50:11 +0000
Subject: Revert "Remove quotes from column selection in
 PGSQLUserProfilesData.SetUserAppData()"

This reverts commit 59c0df962a9dcac896cae2ce9b908be37047825c.
This is necessary to preserve the casing of column names, otherwise pgsql converts everything to lowercase.
TIL, Unlike mysql, a quoted column still refers to the column itself...
---
 OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
index c7b1d8b..48dd4f0 100644
--- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
+++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
@@ -1026,11 +1026,11 @@ namespace OpenSim.Data.PGSQL
             string query = string.Empty;
             
             query += "UPDATE userdata SET ";
-            query += "TagId = :TagId, ";
-            query += "DataKey = :DataKey, ";
-            query += "DataVal = :DataVal WHERE ";
-            query += "UserId = :UserId AND ";
-            query += "TagId = :TagId";
+            query += "\"TagId\" = :TagId, ";
+            query += "\"DataKey\" = :DataKey, ";
+            query += "\"DataVal\" = :DataVal WHERE ";
+            query += "\"UserId\" = :UserId AND ";
+            query += "\"TagId\" = :TagId";
             
             try
             {
-- 
cgit v1.1