aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLRegionData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Massive tab and trailing space cleanupMelanie Thielker2017-01-051-7/+7
|
* fix a typo in dbs region rangeUbitUmarov2016-12-011-1/+1
|
* PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye2016-07-151-4/+2
| | | | | | Some of the fields should probably be migrated to type Boolean to avoid the hairy casting in the query. In addition the overall server code relies in the Replace in SQL statement that is proprietary to MySQL, so the PGSQL code is rather unsafe as it is. Should probably set a transaction on the whole operation so that if something goes wrong the database record is not zapped as it is now. PostgreSQL 9.5 has the upsert functionality which would bring the code closer to the MySQL version. This commit also has an update to PGSQLRegionData Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* Fix region data range selection in the PGSQL backend.TomDataworks2016-01-101-11/+53
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira2013-12-061-1/+1
| | | | http://opensimulator.org/mantis/view.php?id=6868
* 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>
* Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira2013-10-121-0/+392
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.