| From: | Michael Guerin <guerin(at)rentec(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | duplicate key violates unique constraint. (repost) |
| Date: | 2005-07-20 16:10:09 |
| Message-ID: | 42DE7761.2060807@rentec.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
Sorry for the lack of info, but I wanted to get a post out there
while I start to figure out my problem since this is a production database.
We're starting to get a number of complaints about "duplicate key
violations" on a index for one of the toast tables. It started
happening after our server was brought down over the weekend, so I
suspect postgresql wasn't shutdown properly. Below is the description
of the index.
I'm doing a re-index on the user table that is associated with the toast
table, is this the right thing to do? Is there something else I should do?
# \d pg_toast.pg_toast_1916266943_index
Index "pg_toast.pg_toast_1916266943_index"
Column | Type
-----------+---------
chunk_id | oid
chunk_seq | integer
primary key, btree, for table "pg_toast.pg_toast_1916266943"
# select version();
version
------------------------------------------------------------------------
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2
Thanks
michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-07-20 18:08:09 | Re: duplicate key violates unique constraint. (repost) |
| Previous Message | Andrew Stuart | 2005-07-20 10:11:19 | help with a simple SQL query |