Great, I'm also trying to create a reproducable test case for the original
problem i reported with duplicate rows/oids/pkeys. Maybe both problems are
a result of the same bug; i don't know.
BTW, if you remove the index that is based on the pgpsql function
"developer_aka_seach_idx" the problem is not reproducable. But you've
probably figured that out by now.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Brian Hirt" <bhirt@mobygames.com>
Cc: "Postgres Hackers" <pgsql-hackers@postgresql.org>; "Brian A Hirt"
<bhirt@berkhirt.com>
Sent: Tuesday, December 18, 2001 10:52 AM
Subject: Re: [HACKERS] problems with table corruption continued
> "Brian Hirt" <bhirt@mobygames.com> writes:
> > I've attached three files, a typescript, and two sql files. I found
that if
> > the commands were combined into a single file and run in a single pgsql
> > session, the error does not occur -- so it's important to follow the
> > commands exactly like they are in the typescript. If for some reason
the
> > errors aren't reproducable on your machines, let me know and we will try
to
> > find out what's unique about my setup.
>
> Indeed, it reproduces just fine here --- not only that, but I get an
> Assert failure when I try it in current sources.
>
> Many, many thanks! I shall start digging forthwith...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>