Update pg_type possible problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux