Re: Duplicate values found when reindexing unique index

>
>
> Can you show us all the triggers on this table?

Here they are:

Triggers:
entry_correct_published_at_trigger BEFORE INSERT OR UPDATE ON entry FOR
EACH ROW EXECUTE PROCEDURE correct_published_at()
entry_feed_page_trigger BEFORE INSERT OR UPDATE ON entry FOR EACH ROW
EXECUTE PROCEDURE entry_feed_page_trigger()
entry_updated_at_trigger BEFORE UPDATE ON entry FOR EACH ROW EXECUTE
PROCEDURE update_updated_at_timestamp()
feed_entry_count_trigger AFTER INSERT ON entry FOR EACH ROW EXECUTE
PROCEDURE update_feed_entry_count()

> Also, it would be real
> interesting to see "pg_filedump -i -f" output for the two blocks in
> question (1508573 and 1818219) --- see http://sources.redhat.com/rhdb/
> to get a copy of pg_filedump.
>

I have downloaded, compiled and installed pg_filedump -- but I am not sure
how to determine which file I should have it dump. I am not very familiar
with the postgres file structure. Can you please provide some guidance? How
do I determine the correct file?

I've determined the relation "entry" has an oid = 16838 -- but the
/data/base/16830 directory contains 92 1GB files named 16838.[1-92]

I've tried:

pg_filedump -i -f -R 1508573 16838

and got the following error:

[postgres(at)prod-db-2 16830]$ pg_filedump -i -f -R 1508573 16838

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 8.2.0
*
* File: 16838
* Options used: -i -f -R 1508573
*
* Dump created on: Sun Dec 30 23:18:01 2007
*******************************************************************
Error: Seek error encountered before requested start block <1508573>.

I tried a few other files in the 1-92 range with the same results.

Mason