Error from index "pg_type_typname_index"????

From: fabrizio(dot)ermini(at)sysdat(dot)it
To: pgsql-general(at)postgresql(dot)org
Subject: Error from index "pg_type_typname_index"????
Date: 2001-02-12 09:27:04
Message-ID: 3A87BA78.29795.541B09@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tin(dot)it
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini(at)sms(dot)tin(dot)it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DaVinci 2001-02-12 10:52:42 transaction safety
Previous Message Anand Raman 2001-02-12 07:05:58 strange query results