diff options
author | Geir Nøklebye | 2016-07-15 16:34:32 +0200 |
---|---|---|
committer | UbitUmarov | 2016-07-15 15:45:39 +0100 |
commit | 653b896794d884dbdb44dace81d3cf99a93c7705 (patch) | |
tree | e055e0e5375e5cb914a7a1613d0d942c0bc3a52e /OpenSim/Data/PGSQL/PGSQLAssetData.cs | |
parent | lib omv now supports SeeAvs fields, so use it, thx Gavin Hird (diff) | |
download | opensim-SC_OLD-653b896794d884dbdb44dace81d3cf99a93c7705.zip opensim-SC_OLD-653b896794d884dbdb44dace81d3cf99a93c7705.tar.gz opensim-SC_OLD-653b896794d884dbdb44dace81d3cf99a93c7705.tar.bz2 opensim-SC_OLD-653b896794d884dbdb44dace81d3cf99a93c7705.tar.xz |
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>
Diffstat (limited to 'OpenSim/Data/PGSQL/PGSQLAssetData.cs')
0 files changed, 0 insertions, 0 deletions