Howdy, Environment:
Postgres 8.4.2 Gentoo 2.0.1 Server crash over the weekend. After crash customer noticed table missing and when trying to re-create they got error: >[Error] Script lines: 20-33 ------------------------ ERROR: type "solar_promotion_query" already exists Line: 1 _ To resolve they did: BEGIN; update pg_type set typname = 'solar_promotion_query_id_seq_old' where typrelid = 5434806; update pg_type set typname = 'solar_promotion_query_old' where typrelid = 5434808; COMMIT; Everything seems to be fine but wondering if the above action could cause any future issues with relations or any other problems? Thank you, Samuel Stearns
