diff options
author | Justin Clark-Casey (justincc) | 2015-01-13 21:50:11 +0000 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2015-01-13 21:50:11 +0000 |
commit | f9d2121bcf783e6fd1ad519eff57a287bc43598c (patch) | |
tree | e19831ef589696efd6c133c85684e7a2f75f98a0 | |
parent | Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible cast... (diff) | |
download | opensim-SC-f9d2121bcf783e6fd1ad519eff57a287bc43598c.zip opensim-SC-f9d2121bcf783e6fd1ad519eff57a287bc43598c.tar.gz opensim-SC-f9d2121bcf783e6fd1ad519eff57a287bc43598c.tar.bz2 opensim-SC-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.cs | 10 |
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 | { |