UbitUmarov
f2b54c8cf9
mantis 8200: move changes in PGSQL from last commit to a new transaction (13)
2017-11-12 09:16:32 +00:00
TomTheDragon
6a75b7c65e
PGSQL EstateStore create estate_settings_id SEQUENCE
...
Missing creation for estate_settings_id sequence causes first run
to fail unless manually added.
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-11-12 09:07:09 +00:00
TomTheDragon
56d2db3a18
Add a new experimental implementation of PGSQL FSAssets
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-11-03 05:10:37 +00:00
Geir Nøklebye
8f9256ea1c
PGSQL: Another missing cast in XInventoryData
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-22 16:24:52 +01:00
UbitUmarov
dd0269df48
fix passcollisions bool value on store
2017-05-13 17:22:56 +01:00
Geir Nøklebye
7cf82a71d6
PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast that fails with newer versions of NPGSQL.
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-13 17:15:47 +01:00
Geir Nøklebye
03a38a80ab
PGSQL: Rewrote EstateStore.migrations as it errored out in version 8 leaving the database without any estate tables on first run. It also lacked primary keys on estate_map and estate_settings. Syntax requires Postgresql 9.5 or higher.
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-09 12:00:45 +01:00
Geir Nøklebye
d952d62baa
PGSQL: Add missing AgentPrefs.migrations
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-08 20:25:03 +01:00
UbitUmarov
54eb6fc779
GZipStream does have a CopyTo()
2017-05-06 18:25:07 +01:00
UbitUmarov
eb93855d84
dispose some MemoryStreams
2017-05-06 17:47:43 +01:00
Geir Nøklebye
ebcfad1a83
store the physics inertia override in the database
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-04-20 21:21:23 +01:00
Geir Nøklebye
28125202cc
update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing support for fields in the prims table.
...
Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19 14:04:54 -04:00
Geir Nøklebye
fe83763c36
PGSQL: Fixed a failing query in GroupsData for deleting groups messages older than 14 days. The little known abstime function could be used for a double cast. The field TMStamp should be changed to store the data as a proper timestamp. Related to Mantis #7848 . Usually this would easily be solved using the to_timestamp function, but there is no support for it in NPGSQL as there are no very close functionality in .NET
...
Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19 13:40:49 -04:00
Melanie Thielker
b16abc8166
Massive tab and trailing space cleanup
2017-01-05 19:07:37 +00:00
Geir Nøklebye
af93822465
PGSQL fixed a missing cast to uuid in XInventoryData
...
Signed-off-by: Melanie Thielker <melanie@t-data.com>
2017-01-04 21:18:58 +00:00
UbitUmarov
29f6e3fc7b
fix a typo in dbs region range
2016-12-01 04:08:42 +00:00
UbitUmarov
5202ae7bb4
revert changes to asset desc size, my bad.. this field will possible go away in future
2016-11-24 14:39:08 +00:00
UbitUmarov
7524c7729f
change asset description max size
2016-11-22 01:34:07 +00:00
UbitUmarov
d1baa3e0c3
fix some invalid string.format arguments
2016-11-09 22:39:52 +00:00
UbitUmarov
71bd3ce49f
add load baked terrain methods
2016-09-17 16:42:40 +01:00
UbitUmarov
3f9f105295
add to databases a table to store baked terrain.
2016-09-17 15:45:11 +01:00
UbitUmarov
5d5bad5fc1
workaround potencial memory leaks
2016-08-22 06:03:39 +01:00
Geir Nøklebye
653b896794
PGSQL: Update simulation data with a number of missing fields for parcels. 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>
2016-07-15 15:45:39 +01:00
Geir Nøklebye
7aa3d4256e
POSTGRES: Update database migrations to be in accordance with MySQL table definitions. Prerequisite for fixing PGSQLSimulationdata
...
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846 )
2016-04-25 12:17:17 -04:00
Geir Nøklebye
b418033915
Updated the code to handle Agent Preferences. Thanks to TomDataworks for providing a final solution.
...
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610 )
2016-04-25 12:15:34 -04:00
TomDataworks
e9b0f71575
Fix Mantis #7805 , table handler needs to look for all unique constraints.
...
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
2016-04-25 12:11:03 -04:00
Geir Nøklebye
b91cfcca2b
POSTGRES: Added check for Heightfield not equal to Database NULL.. Mirrors OpenSim commit 50d738
...
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7845 )
2016-04-25 12:01:36 -04:00
Melanie Thielker
482daacea7
Add migration to add "active" column on PGSQL. UNTESTED!
2016-03-22 20:55:21 +01:00
Diva Canto
ab12a14279
Pushed AssemblyVersion up to VersionInfo, so that we don't need to do global replace anymore.
2016-02-21 11:14:02 -08:00
TomDataworks
905dec5d23
Fix region data range selection in the PGSQL backend.
...
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-01-10 18:05:08 +00:00
UbitUmarov
cdaed11387
at last we can login and see objects ( friends is dead and disable in
...
scenepresence)
2015-09-03 18:39:08 +01:00
UbitUmarov
a11edceb00
seems to compile ( tests comented out)
2015-09-02 19:54:53 +01:00
UbitUmarov
371c9dd2af
bad merge?
2015-09-01 14:54:35 +01:00
Oren Hurvitz
dc098ef671
Merged the two "Version 2" migrations in PGSQL
2015-08-03 15:34:59 +03:00
Geir Nøklebye
818735ae2c
PGSL Presence migration to correct a double version 2 migration that existed
...
The migration file had a version 2 migration defined twice and
therefore the LastSeen field most likely never was defined in the
presence file. This migration adds the field and migrates the table to
version 4.
Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-08-03 13:32:11 +01:00
Geir Nøklebye
1de8c3570d
PGSQL migrations for IM_Store, UserProfiles, removal of casting exception for UserProfiles and adding double precision to PGSQL Manager
...
PGSQL migrations for IM_Store, UserProfiles, removal of casting
exception for UserProfiles and adding double precision to PGSQL Manager.
Fixes the Offline IM to Email toggle and prepares for fixing Offline
IM.
Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-31 15:57:22 +01:00
Geir Nøklebye
a7fccbcf6f
Update PGSQL groups handler to accept search queries from the viewer
...
Update PGSQL groups handler to accept search queries from the viewer.
Fixed malformed query strings.
Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-26 11:59:15 +01:00
Melanie Thielker
7342192223
Add quotes aroung LandFlags as PGSQL seems to choke on the word when
...
it's bare.
2015-07-23 01:59:33 +02:00
Melanie Thielker
c7f6e248e8
Correcting errors in previous change: MySQL needs int unsigned, not
...
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14 21:22:53 +02:00
Melanie Thielker
7b571a928c
Mantis #7629 : Change LandFlags column to unsigned. Thanks, Jim!
2015-07-14 21:16:25 +02:00
Melanie Thielker
987e7e4f84
Applying Gavin Hird's patch to correct PGSQL group notices. Thatk you,
...
Gavin
2015-06-26 19:08:51 +02:00
dahlia
3aa9e786de
Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord exception PGSQL
2015-06-24 04:08:34 -07:00
dahlia
2c5a3ff9f0
Thanks Gavin Hird for a fix for an exception when requesting an Estate Ban when using PGSQL.
2015-06-24 03:46:30 -07:00
Diva Canto
4a516fa156
Removed the pgsql table for AgentPrefs, because it is not working. For now the Agent Preferences feature will not work with PGSQL installations -- someone who uses PGSQL needs to send a table that works.
2015-06-14 14:49:20 -07:00
Diva Canto
be68f4852c
Mantis #7610 . Changed AgentPrefs table in PGSQL to use uuid instead of varchar(36), to be consistent with the otehr pgsql tables. Since the first commit on this was yesterday, there's no migration; instead, the version starts at 2. If anyone created the table yesterday, it will be dropped and recreated.
...
WARNING: untested. (I don't use pg)
2015-06-14 09:30:55 -07:00
Diva Canto
496f35b4e8
Removing the Store methods in the DB layer of AgentPreferences, as they were simply calling the base ones.
2015-06-14 08:04:25 -07:00
Cinder
3853904b80
Quell three new warnings I introduced with AgentPrefsData, return an empty llsd map instead of an empty llsd block when no AgentPrefs service is available to try and appease Firestorm
...
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-14 07:59:25 -07:00
Cinder
7635138c59
SQLite and PGSQL adapters for AgentPreferences
...
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13 14:53:17 -07:00
Diva Canto
da32512ea4
Updated all occurrences of AssemblyVersion("0.8.1.*") to AssemblyVersion("0.8.2.*")
2015-04-29 18:47:17 -07:00
AliciaRaven
1e444b1449
Change UserProfiles so that the parcel name is used for a ProfilePick and not the parcel owners name. This change also fixes a bug where if the avatar enters and does not move, creating or editing a ProfilePick would set the parcelId as an empty UUID. This is because ScenePresence.currentParcelUUID is not set until the avatar moves.
...
Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2015-04-12 15:36:22 -04:00