[COMMITTERS] pgsql: Fix CREATE TABLE ...

2006-09-17 Thread Tom Lane
Log Message: --- Fix CREATE TABLE ... AS VALUES ... to work rather than Assert'ing; oversight in original implementation of VALUES. Also fix an oversight in recent addition of options to CREATE TABLE AS: they weren't getting propagated if the query was a set-operation such as UNION. Modif

[COMMITTERS] pgsql: Change ANALYZE to take ShareUpdateExclusiveLock not

2006-09-17 Thread Tom Lane
Log Message: --- Change ANALYZE to take ShareUpdateExclusiveLock not AccessShareLock on the table being analyzed. This prevents two ANALYZEs from running concurrently on the same table and possibly suffering concurrent-update failures while trying to store their results into pg_statistic.

[COMMITTERS] pgsql: Marginal cleanup in arrangements for ensuring StrategyHintVacuum

2006-09-17 Thread Tom Lane
Log Message: --- Marginal cleanup in arrangements for ensuring StrategyHintVacuum is cleared after an error during VACUUM. We have a PG_TRY block anyway around the only call sites, so just reset it in the CATCH clause instead of having AtEOXact_Buffers blindly do it during xact end. I thi