Update pg_type possible problems

[Samuel Stearns <SStearns@xxxxxxxxxxxxxxxx>]

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