Opened 16 years ago

Closed 16 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
Cc:

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 by Even Rouault, 16 years ago

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 by warmerdam, 16 years ago

Description: modified (diff)
Milestone: → 1.5.4
Resolution: → fixed
Status: new → closed
Summary: Postgis spatial index impossible through OGR → Postgres 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.