I got these 3 errors while upgrading boost. I have PostgreSQL and did not upgrade boost for a little while. Crazy as I am, I'm using the development version so I do not know exactly at which version I was at. The page_id I had was 255 characters anyway. But what surprises me the most is that the UPDATE from page_id_old to page_id did not fail. That's really strange since if the RENAME fails, the UPDATE should fail too since the old column won't exist. Anyway, just thought I would mention the error. In my case, I'm still in business.

  • warning: pg_query() [function.pg-query]: Query failed: ERROR: index "boost_cache_page_id_idx" does not exist in .../includes/database.pgsql.inc on line 188.
  • user warning: query: DROP INDEX boost_cache_page_id_idx in .../includes/database.pgsql.inc on line 887.
  • warning: pg_query() [function.pg-query]: Query failed: ERROR: column "page_id_old" of relation "boost_cache" already exists in .../includes/database.pgsql.inc on line 188.
  • user warning: query: ALTER TABLE boost_cache RENAME "page_id" TO "page_id_old" in .../includes/database.pgsql.inc on line 953.
  • warning: pg_query() [function.pg-query]: Query failed: ERROR: column "page_id" of relation "boost_cache" already exists in .../includes/database.pgsql.inc on line 188.
  • user warning: query: ALTER TABLE boost_cache ADD COLUMN page_id varchar(255) default '' in .../includes/database.pgsql.inc on line 733.

boost module
Update #6128

  • Failed: DROP INDEX {boost_cache}_page_id_idx
  • Failed: ALTER TABLE {boost_cache} RENAME "page_id" TO "page_id_old"
  • Failed: ALTER TABLE {boost_cache} ADD COLUMN page_id varchar(255) default ''
  • UPDATE {boost_cache} SET page_id = CAST(page_id_old AS varchar)
  • ALTER TABLE {boost_cache} ALTER page_id SET NOT NULL
  • ALTER TABLE {boost_cache} DROP COLUMN page_id_old
  • CREATE INDEX {boost_cache}_page_id_idx ON {boost_cache} (page_id)
  • DROP INDEX {boost_cache_settings}_page_id_idx
  • ALTER TABLE {boost_cache_settings} RENAME "page_id" TO "page_id_old"
  • ALTER TABLE {boost_cache_settings} ADD COLUMN page_id varchar(255) default ''
  • UPDATE {boost_cache_settings} SET page_id = CAST(page_id_old AS varchar)
  • ALTER TABLE {boost_cache_settings} ALTER page_id SET NOT NULL
  • ALTER TABLE {boost_cache_settings} DROP COLUMN page_id_old
  • CREATE INDEX {boost_cache_settings}_page_id_idx ON {boost_cache_settings} (page_id)
  • DROP INDEX {boost_cache_relationships}_page_id_idx
  • ALTER TABLE {boost_cache_relationships} RENAME "page_id" TO "page_id_old"
  • ALTER TABLE {boost_cache_relationships} ADD COLUMN page_id varchar(255) default ''
  • UPDATE {boost_cache_relationships} SET page_id = CAST(page_id_old AS varchar)
  • ALTER TABLE {boost_cache_relationships} ALTER page_id SET NOT NULL
  • ALTER TABLE {boost_cache_relationships} DROP COLUMN page_id_old
  • CREATE INDEX {boost_cache_relationships}_page_id_idx ON {boost_cache_relationships} (page_id)
  • DROP INDEX {boost_cache_relationships}_child_page_id_idx
  • ALTER TABLE {boost_cache_relationships} RENAME "child_page_id" TO "child_page_id_old"
  • ALTER TABLE {boost_cache_relationships} ADD COLUMN child_page_id varchar(255) default ''
  • UPDATE {boost_cache_relationships} SET child_page_id = CAST(child_page_id_old AS varchar)
  • ALTER TABLE {boost_cache_relationships} ALTER child_page_id SET NOT NULL
  • ALTER TABLE {boost_cache_relationships} DROP COLUMN child_page_id_old
  • CREATE INDEX {boost_cache_relationships}_child_page_id_idx ON {boost_cache_relationships} (child_page_id)

    • Thank you.
    Alexis Wilke