[Opensim-dev] PGSQL update git....

André Verwijs dutch.glory at yahoo.com
Sat Jul 16 17:13:31 UTC 2016


(opensim git master)

 >commit 653b896794d884dbdb44dace81d3cf99a93c7705
 >Author: Geir Nøklebye <geir.noklebye at dayturn.com>
 >Date:   Fri Jul 15 16:34:32 2016 +0200
 >
 >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 at sapo.pt>


thanks for this... keep working on it...
André















-- 
______________________________________________________________________________________
La Ventura (heavy metal band) Tumblr page:
http://laventurafan.tumblr.com

My Twitter Page:
http://twitter.com/OpenSimFan

My Facebook page (be my friend, please )
http://www.facebook.com/andre.verwijs

My Google+ page (follow me please )
André Verwijs - Google+ https://plus.google.com/111310545842863442992



More information about the Opensim-dev mailing list