ERROR: cannot insert duplicate... on VACUUM ANALYZE
От | Jon Lapham |
---|---|
Тема | ERROR: cannot insert duplicate... on VACUUM ANALYZE |
Дата | |
Msg-id | 3BC30537.4020905@extracta.com.br обсуждение исходный текст |
Ответы |
Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE
|
Список | pgsql-general |
Hello- When running a routine VACUUM ANALYZE on one of our databases (pg v7.1.2) the following message appears: main_v0_8=# VACUUM ANALYZE ; ERROR: Cannot insert a duplicate key into unique index admin_users_pkey This primary key is referring to the following table: main_v0_8=# \d admin_users Table "admin_users" Attribute | Type | Modifier --------------+--------------------------+------------------------------------------------------ id | smallint | not null default nextval('admin_users_id_seq'::text) name | character varying(255) | not null password | character varying(20) | not null email | character varying(255) | fullname | character varying(255) | usertype | smallint | not null default 1 mygroup | smallint | not null default 1 active | boolean | not null default 't' remoteip | character varying(15) | sessioncode | character varying(20) | lastconnect | timestamp with time zone | lastip | character varying(15) | firstconnect | timestamp with time zone | Indices: admin_users_name_key, admin_users_pkey Any suggestions on how to track down what is happening? I am not actually trying to insert anything to this table, so this error message appears a bit strange to me. One other bit of info, one (of the approx 40) users of this database is receiving the same error message and is unable to work, while the other users are having no problems. Strange. -- -**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*--- Jon Lapham Extracta Moléculas Naturais, Rio de Janeiro, Brasil email: lapham@extracta.com.br web: http://www.extracta.com.br/ ***-*--*----*-------*------------*--------------------*---------------
В списке pgsql-general по дате отправления: