[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