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