Error from index "pg_type_typname_index"????

Поиск
Список
Период
Сортировка
От fabrizio.ermini@sysdat.it
Тема Error from index "pg_type_typname_index"????
Дата
Msg-id 3A87BA78.29795.541B09@localhost
обсуждение исходный текст
Ответы Re: Error from index "pg_type_typname_index"????  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all...

I've a postgresql 7.0.2 used as a backend for a website. Randomly,
and not very frequently, an error pops up saying that the following
problem has happened:

ERROR: Cannot insert a duplicate key into unique index
pg_type_typname_index

The query causing it it's an innocent query that duplicates a table
in a temporary one, i.e.

"select * into forum_clone from forums"

That of course doesn't cause any problem 99% of the time. The
fact that it happens doesn't seem to be related to load, neither
vacuumize the db seems to change anything.

Now my question is: anybody has a hint on what mey be
happening in that darn 1%???

TIA,
Ciao!


/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Fabrizio Ermini               Alternate E-mail:
C.so Umberto, 7               faermini@tin.it
loc. Meleto Valdarno          Mail on GSM: (keep it short!)
52020 Cavriglia (AR)          faermini@sms.tin.it

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

Предыдущее
От: Anand Raman
Дата:
Сообщение: strange query results
Следующее
От: DaVinci
Дата:
Сообщение: transaction safety