[fdo-trac] #354: PostGIS Defect : cursor name conflict make provider crash

[FDO]

#354: PostGIS Defect : cursor name conflict make provider crash
------------------------------+---------------------------------------------
 Reporter:  bscott            |         Owner:  mloskot
     Type:  defect            |        Status:  new    
 Priority:  blocker           |     Milestone:  3.4.0  
Component:  PostGIS Provider  |       Version:  3.2.0  
 Severity:  1                 |    Resolution:         
 Keywords:                    |   External_id:         
------------------------------+---------------------------------------------
Comment (by bscott):

 Before the boostdatetime dependency removal we had a millisecond based
 cursor name, i've changed it for a similar algo having the date + hour +
 minute + second + clock() where clock is millisecond based. But we still
 have cursor name conflict.
 I suggest this
 date + hour + minute + second + clock() + rand() without any seeds.
 The only way of having the same cursor name is to start 2 mapguide server
 and initialise there FIRST connection to PostGIS at the same millisecond.

 It's still not 100% safe but it's really safer , dividing the probalitity
 of a clash by RAND_MAX(32767)

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/354#comment:3>
FDO <http://fdo.osgeo.org/>
Feature Data Objects