Horton

Re: BUG #2379: Duplicate pkeys in table

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-bugs@postgresql.org, Michael Fuhr <mike@fuhr.org>
Date: 2006-04-06T14:27:23Z
Lists: pgsql-bugs 
Philip Warner wrote:

> # set enable_indexscan=off;
> # SELECT xmin, xmax, cmin, cmax FROM xxx where id = 24613;
>    xmin   |   xmax   | cmin |   cmax
> ----------+----------+------+----------
>  32902771 |        0 |   20 | 32902872
>  32902771 |        0 |   20 | 32902872
>  32902771 |        0 |   20 | 32902872
>  32902771 |        0 |   20 | 32902872
>  32902771 |        0 |   20 | 32902872
>  32902771 | 33048159 |   20 |       20
> (6 rows)

Ugh.

Do the triggers involved have EXCEPTION clauses?  (I assume they are
written in PL/pgSQL -- are there any in other languages?)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.