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

Поиск
Список
Период
Сортировка
От Rusty Conover
Тема Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Дата
Msg-id DDDCC758-959B-4750-BAFC-8BB0F38C73ED@infogears.com
обсуждение исходный текст
Ответы Re: Bug: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Список pgsql-bugs
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"

The command that causes it is:

create temp table register_reqs(full_key text, register_index
integer) WITHOUT OIDS ON COMMIT DROP

Is this being caused by a race condition?  Does the "create table"
command acquire any locks?

# select version();
                                               version
------------------------------------------------------------------------
---------------------------
PostgreSQL 8.1.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.1.0 20060304 (Red Hat 4.1.0-3)
(1 row)

This is on Fedora Core 4.

Thanks,

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

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

Предыдущее
От: "Thomas H."
Дата:
Сообщение: Re: BUG #2712: could not fsync segment: Permission
Следующее
От: Алексей Заяц
Дата:
Сообщение: Re: BUG #2724: Could not check connection status with "ssl=on"