Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"

Поиск
Список
Период
Сортировка
От Rusty Conover
Тема Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Дата
Msg-id 2CE290BD-8E17-4884-B432-48FDBFF53EB4@infogears.com
обсуждение исходный текст
Ответ на Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Следующее
От: "Thomas H."
Дата:
Сообщение: beta2: process crash: server process (PID 4872) exited with exit code -1073741819