Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Date
Msg-id 15935.1162220182@sss.pgh.pa.us
Whole thread Raw
In response to Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"  (Rusty Conover <rconover@infogears.com>)
Responses Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
List pgsql-bugs
Tree view 
Rusty Conover <rconover@infogears.com> writes:
> Under a period of high load it seems that creating a temporary tables
> with the same name in separate postgres back-ends can trigger this
> error:
> ERROR:  duplicate key violates unique constraint
> "pg_type_typname_nsp_index"

Can you create a reproducible test case?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Алексей Заяц
Date:
Subject: Re: BUG #2724: Could not check connection status with "ssl=on"
Next
From: Rusty Conover
Date:
Subject: Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"