Opened 11 years ago

Closed 11 years ago

#2619 closed defect (fixed)

Postgres driver does not support ExecuteSQL VACUUM.

Reported by: warmerdam Owned by: warmerdam
Priority: normal Milestone: 1.5.4
Component: OGR_SF Version: 1.5.0
Severity: normal Keywords: postgres postgis pg

Description (last modified by warmerdam)

Currently 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().

Change History (2)

comment:1 Changed 11 years ago by Even Rouault

I guess this ticket is meant to be 1.5 only ? as trunk supports by default the creation of spatial index with CreateLayer?() now. But we may need the trick commited in r15561 to allow doing vaccuum in trunk too.

comment:2 Changed 11 years ago by warmerdam

Description: modified (diff)
Milestone: 1.5.4
Resolution: fixed
Status: newclosed
Summary: Postgis spatial index impossible through OGRPostgres driver does not support ExecuteSQL VACUUM.

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).

Note: See TracTickets for help on using tickets.