aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* | | | | Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)2015-01-131-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
* | | | | Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
* | | | | Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-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...
* | | | | Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)2015-01-131-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)2015-01-131-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
* | | | | Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2015-01-131-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.
* | | | | Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | This may have been preventing it from working.
* | | | | Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()
* | | | | Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserAppData()
* | | | | Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
* | | | | Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PGSQLUserProfilesData.UpdateAvatarProperties() This may have been preventing it from working.
* | | | | Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes()Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | | | | | | | | | | | | | This may have been preventing it from working.
* | | | | Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks()Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | | | | | | | | | | | | | This may have been preventing it from working.
* | | | | minor: correct two exception messages in PGSQLUserProfilesData where I ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | | | | | | | | | | | | | | | copy/pasted AgentInterestsUpdate twice
* | | | | Remove the locking in PGSQLUserProfilesData which was buggy (Lock object ↵Justin Clark-Casey (justincc)2015-01-121-30/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | wasn't set!) and is unnecessary. Relates to http://opensimulator.org/mantis/view.php?id=7398
* | | | | Get PGSQL UserProfilesData to log the exception trace for debugging rather ↵Justin Clark-Casey (justincc)2015-01-091-46/+54
| | | | | | | | | | | | | | | | | | | | than just the exception message.
* | | | | Fix whitespace hoping to avoid a floggingBlueWall2014-11-251-4/+4
| | | | |
* | | | | Re-work handling of email notifications settings.BlueWall2014-11-241-3/+0
| | | | |
* | | | | Fix handling of user preference updates where no email address is suppliedBlueWall2014-11-231-3/+8
| | | | |
* | | | | Fix some typecasting in PgSQL Groups adapterBlueWall2014-10-161-4/+8
| | | | |
* | | | | Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall2014-10-161-19/+0
| | | | | | | | | | | | | | | | | | | | error preventing migration from running.
* | | | | Touchup PgSQL XAssets adapterBlueWall2014-10-152-11/+28
| | | | |
* | | | | Fix over zealous chopping of text when editing (pilot error)BlueWall2014-10-151-1/+1
| | | | |
* | | | | Fix logging level to Error in exception handlersBlueWall2014-10-151-18/+18
| | | | |
* | | | | Cleanup unused codeBlueWall2014-10-151-30/+7
| | | | |
* | | | | Fix PgSQL adapter for UserProfilesBlueWall2014-10-152-178/+256
| | | | |
* | | | | Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall2014-10-121-0/+107
| | | | | | | | | | | | | | | | | | | | generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
* | | | | Make column names lower-case, change hash column type to bytea and remove ↵BlueWall2014-10-122-52/+80
| | | | | | | | | | | | | | | | | | | | old commented lines of code
* | | | | Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall2014-10-102-21/+58
| | | | | | | | | | | | | | | | | | | | query syntax more in line with the PgSQL AssetData implementation.
* | | | | Change assembly versions to 0.8.1Justin Clark-Casey (justincc)2014-06-171-1/+1
| | | | |
* | | | | Change Assembly verson of OpenSim.Data.PGSQL.dll to 0.8.0.* to match all ↵Justin Clark-Casey (justincc)2014-05-271-1/+1
| | | | | | | | | | | | | | | | | | | | other assembly versions
* | | | | minor: eliminate now unnecessary string.Format in postgresql RetrieveGroups ↵Justin Clark-Casey (justincc)2014-05-151-1/+1
| | | | | | | | | | | | | | | | | | | | method
* | | | | Escape find string in PgSQL core groups pluginJustin Clark-Casey (justincc)2014-05-152-3/+25
| | | | |
* | | | | Eliminated many warningsOren Hurvitz2014-04-231-1/+1
| | | | |
* | | | | Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz2014-04-221-4/+4
| | | | | | | | | | | | | | | | | | | | pre-truncate the description of dynamic textures.
* | | | | Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2014-04-022-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.
* | | | | Repair database routines so they properly return null when asked forRobert Adams2014-01-281-1/+5
| | | | | | | | | | | | | | | | | | | | the heighmap of a region that does not exist.
* | | | | Merge branch 'master' into varregionRobert Adams2013-12-172-15/+23
|\ \ \ \ \ | | |_|_|/ | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | Add new region crossing code to varregion Conflicts: OpenSim/Region/CoreModules/Framework/EntityTransfer/EntityTransferModule.cs OpenSim/Region/Framework/Scenes/ScenePresence.cs
| * | | | Add support for user preferences (im via email)BlueWall2013-12-062-15/+23
| | |_|/ | |/| |
* | | | Merge branch 'master' into varregionRobert Adams2013-12-052-3/+1
|\ \ \ \ | |/ / /
| * | | Adding profile partners fix to SQLite and PgSQL driversBlueWall2013-12-051-2/+0
| | | |
| * | | Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira2013-12-061-1/+1
| | | | | | | | | | | | | | | | http://opensimulator.org/mantis/view.php?id=6868
* | | | Merge branch 'master' into varregionRobert Adams2013-12-011-2/+2
|\ \ \ \ | |/ / /
| * | | Corrected case to get columns from Regions table from PostgreSQL ↵Fernando Oliveira2013-11-251-2/+2
| | |/ | |/| | | | | | | | | | | | | http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* | | Merge branch 'master' into varregionRobert Adams2013-11-241-4/+5
|\ \ \ | |/ /
| * | Fixed the update StoreRegionWindlightSettings() wasn't updating ↵Fernando Oliveira2013-11-221-4/+5
| |/ | | | | | | | | | | | | regionwindlight table, raising PrimaryKey violation; Signed-off-by: Fernando Oliveira <fernando@oliveira.eti.br> Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>