Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"

[Melvin Davidson <melvin6925@xxxxxxxxx>]

What this indicates is that someone, or some thing, is trying to create a table in a schema that already exists.

Here is the structure of pg_class_relname_nsp_index:
CREATE UNIQUE INDEX pg_class_relname_nsp_index ON pg_class USING btree (relname, relnamespace)

What you should also see in the error log is a line immediately following that error which shows you exactly what the conflict is, but you have not provided that to us.

On Wed, May 27, 2015 at 4:19 AM, Mitu Verma <mitu.verma@xxxxxxxxxxxx> wrote:

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

 

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.