Changes between Initial Version and Version 1 of Ticket #4567


Ignore:
Timestamp:
Mar 20, 2012, 11:49:44 AM (12 years ago)
Author:
warmerdam
Comment:

I have briefly reviewed the patch and it looks pretty good.

I notice that username and password items are also now being pulled from the connection string and this appears to be new, but is not mentioned in the ticket.

I've made a few minor other adjustments and prepared a new patch (attached), which I'd appreciate your reviewing and testing.

Also, I can't apply the INGRES.htm as is. Please prepare a patch or new version of drv_ingres.html and do *not* edit it with an HTML editor that will insert lots of cruft.

As these are new features we will incorporate them in trunk. We can discuss backporting to 1.9 once we are happy with the changes in 2.0 if the changes are necessary for 1.9 to function.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4567

    • Property Keywords ogr removed
    • Property Owner changed from warmerdam@… to warmerdam
    • Property Status new → assigned
    • Property Milestone 1.9.1

  • Ticket #4567 – Description

    initial v1  
    22
    331. Add two key words to the connection string that are used in database authorization.
     4{{{
    45  effuser is for the real user in database
    56  dbpwd is for the password of the effuser
     7}}}
    68
    79It fits the situation that OS authorization user is not the same name with database user name. Ingres requires double authorization check.
    810
    9112. Enhance EPSG srid search in database. The previous method is to match the text string representation of a EPSG srid. It is not accuate if there is minor different. Now before a text matching search, a query is execute directly to get the srs_id and confirm:
    10  '''SELECT srid FROM spatial_ref_sys WHERE auth_name = 'EPSG' and auth_srid= %s'''
     12{{{
     13 SELECT srid FROM spatial_ref_sys WHERE auth_name = 'EPSG' and auth_srid= %s
     14}}}
    1115
    12163. Using system maintained sequence for each fid field in each table instead of the global defined sequence: