Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Table has duplicate keys, what did I do
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: John Gateley <gateley(at)jriver(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Table has duplicate keys, what did I do
- Date: Tue, 29 Jan 2008 12:53:11 -0500
John Gateley <gateley(at)jriver(dot)com> writes: > Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: >> John Gateley <gateley(at)jriver(dot)com> writes: >>> Somehow I have managed to have two tables with duplicate keys. >> 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. There was a fix released in 8.1.9 for a problem that could cause VACUUM FULL to create duplicate copies of a row that had recently been updated. Does that sound like a plausible scenario for your usage? regards, tom lane
- Follow-Ups:
- Re: Table has duplicate keys, what did I do
- From: John Gateley
- Re: Table has duplicate keys, what did I do
- References:
- Table has duplicate keys, what did I do
- From: John Gateley
- Re: Table has duplicate keys, what did I do
- From: Tom Lane
- Re: Table has duplicate keys, what did I do
- From: John Gateley
- Table has duplicate keys, what did I do
- Prev by Date: Re: referencing to "computed columns" in where clause
- Next by Date: postgresql book - practical or something newer?
- Previous by thread: Re: Table has duplicate keys, what did I do
- Next by thread: Re: Table has duplicate keys, what did I do
- Indexes: