From 0ad45531a18ad577b36818fbe5f51f23ff4a2a9b Mon Sep 17 00:00:00 2001 From: Fernando Oliveira Date: Mon, 25 Nov 2013 21:20:56 -0200 Subject: Corrected case to get columns from Regions table from PostgreSQL http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni --- OpenSim/Data/PGSQL/PGSQLRegionData.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'OpenSim/Data/PGSQL') diff --git a/OpenSim/Data/PGSQL/PGSQLRegionData.cs b/OpenSim/Data/PGSQL/PGSQLRegionData.cs index 8a46559..f3e4064 100644 --- a/OpenSim/Data/PGSQL/PGSQLRegionData.cs +++ b/OpenSim/Data/PGSQL/PGSQLRegionData.cs @@ -206,7 +206,7 @@ namespace OpenSim.Data.PGSQL DataTable schemaTable = result.GetSchemaTable(); foreach (DataRow row in schemaTable.Rows) - m_ColumnNames.Add(row["ColumnName"].ToString()); + m_ColumnNames.Add(row["column_name"].ToString()); } foreach (string s in m_ColumnNames) @@ -376,7 +376,7 @@ namespace OpenSim.Data.PGSQL private List Get(int regionFlags, UUID scopeID) { - string sql = "SELECT * FROM " + m_Realm + " WHERE (flags & " + regionFlags.ToString() + ") <> 0"; + string sql = "SELECT * FROM " + m_Realm + " WHERE (\"flags\" & " + regionFlags.ToString() + ") <> 0"; if (scopeID != UUID.Zero) sql += " AND \"ScopeID\" = :scopeID"; -- cgit v1.1