aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2015-01-13 21:50:11 +0000
committerJustin Clark-Casey (justincc)2015-01-13 21:50:11 +0000
commitf9d2121bcf783e6fd1ad519eff57a287bc43598c (patch)
treee19831ef589696efd6c133c85684e7a2f75f98a0
parentFix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible cast... (diff)
downloadopensim-SC_OLD-f9d2121bcf783e6fd1ad519eff57a287bc43598c.zip
opensim-SC_OLD-f9d2121bcf783e6fd1ad519eff57a287bc43598c.tar.gz
opensim-SC_OLD-f9d2121bcf783e6fd1ad519eff57a287bc43598c.tar.bz2
opensim-SC_OLD-f9d2121bcf783e6fd1ad519eff57a287bc43598c.tar.xz
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...
-rw-r--r--OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs10
1 files changed, 5 insertions, 5 deletions
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
1026 string query = string.Empty; 1026 string query = string.Empty;
1027 1027
1028 query += "UPDATE userdata SET "; 1028 query += "UPDATE userdata SET ";
1029 query += "TagId = :TagId, "; 1029 query += "\"TagId\" = :TagId, ";
1030 query += "DataKey = :DataKey, "; 1030 query += "\"DataKey\" = :DataKey, ";
1031 query += "DataVal = :DataVal WHERE "; 1031 query += "\"DataVal\" = :DataVal WHERE ";
1032 query += "UserId = :UserId AND "; 1032 query += "\"UserId\" = :UserId AND ";
1033 query += "TagId = :TagId"; 1033 query += "\"TagId\" = :TagId";
1034 1034
1035 try 1035 try
1036 { 1036 {