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: | Whole Thread | Raw Message | 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
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 |