CREATE UNIQUE INDEX pg_class_relname_nsp_index ON pg_class USING btree (relname, relnamespace)
HI,
Following error is continuously seen with the postgreSQL database which we are using at customer site.
Current Errors observed: ./fm_db_VoiceReprocessing1/data/pg_log/postgresql-04.log:2015-04-04 01:00:16 CESTERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Any pointers on why these errors are coming? What is the meaning of duplicate key value violates unique constraint "pg_class_relname_nsp_index"
If it is due to some index corruption or duplicate index? Please help.
Following tables are used frequently in our case
CREATE TABLE AuditTrailLogEntry
(
event int2,
inNodeID VARCHAR(80),
inNodeName VARCHAR(80),
sourceID VARCHAR(300),
inTime TIMESTAMP, -- YYYY/MM/DD HH:MM:SS.mmm
outNodeID VARCHAR(80),
outNodeName VARCHAR(80),
destinationID VARCHAR(300),
outTime TIMESTAMP, -- YYYY/MM/DD HH:MM:SS.mmm
bytes bigint,
cdrs bigint,
tableIndex bigint, -- Unique key
noOfSubfilesInFile bigint,
recordSequenceNumberList VARCHAR(1000),
primary key (tableindex)
) TABLESPACE MMDATA; –
CREATE TABLE EventLogEntry
(
tableIndex int4, -- Unique key
object VARCHAR(80),
method VARCHAR(80),
bgwUser VARCHAR(80),
time CHAR(23), -- YYYY/MM/DD HH:MM:SS.mmm
realUser VARCHAR(80),
host VARCHAR(80),
application VARCHAR(80)
) TABLESPACE MMDATA;
Regards
Mitu
--
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.