duplicate key value violates unique constraint "pg_class_relname_nsp_index"

Поиск
Список
Период
Сортировка
От Mitu Verma
Тема duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Дата
Msg-id 84BC7AB0D621A74893EC9C9E151293B0226AD107@ESESSMB207.ericsson.se
обсуждение исходный текст
Ответы Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Список pgsql-general

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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Medhavi Mahansaria
Дата:
Сообщение: Re: Reg: BULK COLLECT
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Can we simulate Oracle Flashback with pg_export_snapshot()?