On 27 May 2015 at 09:57, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
>
> Mitu Verma wrote:
> > 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.
>
> This is perfectly harmless from a data integrity point of view, it is just an error
> message that the user gets when he or she tries to insert a row whose primary key
> already exists in the table:
>
> Mitu Verma wrote:
> > 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.
>
> This is perfectly harmless from a data integrity point of view, it is just an error
> message that the user gets when he or she tries to insert a row whose primary key
> already exists in the table:
But the constraint here is pg_class_relname_nsp_index - the unique index on pg_class (relname, relnamespace). You don't get that error if you try to create a table that already exists. How could you end up with that error (short of attempting to directly insert rows in pg_class)?
