On Mon, 28 Jan 2008 21:36:35 -0500 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > John Gateley <gateley@xxxxxxxxxx> writes: > > Somehow I have managed to have two tables with duplicate keys. > > ... > > But, mostly, I'm wondering how I managed to get in this state, > > What PG version is this? We've fixed some bugs in the past that > could give rise to duplicated rows. Currently 8.1.4, and it's been tracking Ubuntu 6.06 LTS for updates, so it could have been earlier than 8.1.4 when the duplicate row actually was created. Thanks, j -- John Gateley <gateley@xxxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/