Update pg_type possible problems

From: Samuel Stearns <SStearns(at)internode(dot)com(dot)au>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Update pg_type possible problems
Date: 2013-05-20 01:32:36
Message-ID: CBAC86BE623FDB4E8B6225471691724291F67CD8@EXCHMBX-ADL6-01.staff.internode.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Armand du Plessis 2013-05-20 09:41:30 Re: Transaction ID wrap limit is log entries
Previous Message Amit Langote 2013-05-20 00:36:48 Re: Steps to switch from Master to standby mode :