aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-01-14Use ToString() on uuids returned in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets(). These are Guids rather than strings so casting to string generates a casting exception. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)1-0/+1
exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
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
generated by cgit v1.1 at 2025-02-10 04:03:23 +0000