aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
2015-01-13Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
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...
2015-01-13Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)1-3/+3
casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)1-1/+1
UUID to the uuid parameter instead of its ToString() This may well be the cause behind "operator does not exist: uuid = character varying" pgsql errors. If so, the other instances will also be changed. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)1-1/+1
set the UserId parameter instead of the non-existing Id parameter when writing a record because none yet exists. SQLite version is already correct for this.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)1-5/+5
This may have been preventing it from working.
2015-01-13Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)1-1/+1
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13minor: correct two exception messages in PGSQLUserProfilesData where I ↵Justin Clark-Casey (justincc)1-2/+2
copy/pasted AgentInterestsUpdate twice
2015-01-12Remove the locking in PGSQLUserProfilesData which was buggy (Lock object ↵Justin Clark-Casey (justincc)1-30/+9
wasn't set!) and is unnecessary. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-09Get PGSQL UserProfilesData to log the exception trace for debugging rather ↵Justin Clark-Casey (justincc)1-46/+54
than just the exception message.
2014-11-25Fix whitespace hoping to avoid a floggingBlueWall1-4/+4
2014-11-24Re-work handling of email notifications settings.BlueWall1-3/+0
2014-11-23Fix handling of user preference updates where no email address is suppliedBlueWall1-3/+8
2014-10-16Fix some typecasting in PgSQL Groups adapterBlueWall1-4/+8
2014-10-16Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall1-19/+0
error preventing migration from running.
2014-10-15Touchup PgSQL XAssets adapterBlueWall2-11/+28
2014-10-15Fix over zealous chopping of text when editing (pilot error)BlueWall1-1/+1
2014-10-15Fix logging level to Error in exception handlersBlueWall1-18/+18
2014-10-15Cleanup unused codeBlueWall1-30/+7
2014-10-15Fix PgSQL adapter for UserProfilesBlueWall2-178/+256
2014-10-12Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall1-0/+107
generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
2014-10-12Make column names lower-case, change hash column type to bytea and remove ↵BlueWall2-52/+80
old commented lines of code
2014-10-10Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall2-21/+58
query syntax more in line with the PgSQL AssetData implementation.
2014-06-17Change assembly versions to 0.8.1Justin Clark-Casey (justincc)1-1/+1
2014-05-27Change Assembly verson of OpenSim.Data.PGSQL.dll to 0.8.0.* to match all ↵Justin Clark-Casey (justincc)1-1/+1
other assembly versions
2014-05-15minor: eliminate now unnecessary string.Format in postgresql RetrieveGroups ↵Justin Clark-Casey (justincc)1-1/+1
method
2014-05-15Escape find string in PgSQL core groups pluginJustin Clark-Casey (justincc)2-3/+25
2014-04-23Eliminated many warningsOren Hurvitz1-1/+1
2014-04-22Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz1-4/+4
pre-truncate the description of dynamic textures.
2014-04-02Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2-7/+65
list of assets exist. This method is used to optimize sending assets with embedded assets: e.g., when a Hypergrid visitor takes an item into the inventory.
2014-01-28Repair database routines so they properly return null when asked forRobert Adams1-1/+5
the heighmap of a region that does not exist.
2013-12-06Add support for user preferences (im via email)BlueWall2-15/+23
2013-12-05Adding profile partners fix to SQLite and PgSQL driversBlueWall1-2/+0
2013-12-06Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira1-1/+1
http://opensimulator.org/mantis/view.php?id=6868
2013-11-25Corrected case to get columns from Regions table from PostgreSQL ↵Fernando Oliveira1-2/+2
http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-11-22Fixed the update StoreRegionWindlightSettings() wasn't updating ↵Fernando Oliveira1-4/+5
regionwindlight table, raising PrimaryKey violation; Signed-off-by: Fernando Oliveira <fernando@oliveira.eti.br> Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-11-04varregion: remove unused terrain serialization code in SQLite and PGSQL modulesRobert Adams1-24/+0
2013-11-01varregion: push TerrainData implementation up and down the database storage ↵Robert Adams1-24/+24
stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
2013-10-16Corrected estateID to EstateID on getEstates function at PGSQLEstateData.csFernando Oliveira1-1/+1
2013-10-16* One More thing, add an appdomain data element to ensure that we don't ↵Fernando Oliveira2-4/+15
duplicate the assembly resolving.
2013-10-16* Fixes mantis mantis 0006803 [PGSQL] - Simulator crashes - ↵Fernando Oliveira2-0/+47
Mono.Security.dll missing. The root of the issue is that the Postgres driver relies on Mono.Security.dll from the mono project. Unfortunately, when using Mono, including the dll in the distribution causes conflicts. This solution puts Mono.Security.dll in bin/lib/NET/ and, if windows .NET is the runtime, informs the assembly loader to load bin/lib/NET/Mono.Security.dll when .NET is scanning for the Mono.Security namespace. On Mono, the included Mono.Security assembly is ignored.
2013-10-16varregion: update PGSQL driver for storing variable terrain size blobs.Robert Adams1-15/+30
generated by cgit v1.1 at 2024-09-13 17:46:32 +0000