Changes between Initial Version and Version 2 of Ticket #2619


Ignore:
Timestamp:
Oct 20, 2008, 2:07:22 PM (16 years ago)
Author:
warmerdam
Comment:

As Even has pointed out, trunk already support spatial indexing with the SPATIAL_INDEX layer creation option. I have revised this ticket to just be about allowing VACUUM ANALYSE through without a transaction in ExecuteSQL(). This is in 1.5 branch (r15561) and trunk (r15564).

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2619

    • Property Status new → closed
    • Property Milestone → 1.5.4
    • Property Resolution → fixed
    • Property Summary Postgis spatial index impossible through OGR → Postgres driver does not support ExecuteSQL VACUUM.

  • Ticket #2619 – Description

    initial v2  
    1 Currently the OGR PG driver does not support building a spatial index for spatial tables created with CreateLayer().  Furthermore, it is not even possible to create a spatial index, and then do a vacuum analyse through the ExecuteSQL() because a vacuum operation cannot be done within a transaction and there is no way to avoid doing SQL not in a transaction using ExecuteSQL().
     1Currently the OGR PG driver does not support doing a vacuum analyse through the ExecuteSQL() because a vacuum operation cannot be done within a transaction and there is no way to avoid doing SQL not in a transaction using ExecuteSQL().