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

On Oct 30, 2006, at 7:56 AM, Tom Lane wrote:

> 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

Hi Tom,

I'm able to reproduce it.  It's happened twice in the last 8 hours.
I'm not yet able to provide an easy to trigger test case.

Rusty
--
Rusty Conover
InfoGears Inc.
Web: http://www.infogears.com