Re: [BUGS] Violation of primary key constraint

2013-02-01 Thread Toby Murray
On Fri, Feb 1, 2013 at 3:58 PM, Tom Lane wrote: > Toby Murray writes: >> On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote: >>> Could we see the full results of heap_page_items(get_raw_page()) for >>> each of the pages where any of these tuples live, viz > >> S

Re: [BUGS] Violation of primary key constraint

2013-01-31 Thread Toby Murray
On Thu, Jan 31, 2013 at 11:21 PM, Toby Murray wrote: > Also, the node change happened on January 28th. To be precise, the > timestamp of the node is 2013-01-28 02:38:29. So it is looking like > something may have gone wrong, possibly in a single minutely update, > on January 28t

Re: [BUGS] Violation of primary key constraint

2013-01-31 Thread Toby Murray
On Thu, Jan 31, 2013 at 10:57 PM, Toby Murray wrote: > On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote: >> Toby Murray writes: >>> I just had some interaction with RhodiumToad on IRC about a duplicated >>> primary key problem I ran into today. After some poking aro

Re: [BUGS] Violation of primary key constraint

2013-01-31 Thread Toby Murray
On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote: > Toby Murray writes: >> I just had some interaction with RhodiumToad on IRC about a duplicated >> primary key problem I ran into today. After some poking around he >> suggested that I send this to -bugs since it seems like an

[BUGS] Violation of primary key constraint

2013-01-31 Thread Toby Murray
I just had some interaction with RhodiumToad on IRC about a duplicated primary key problem I ran into today. After some poking around he suggested that I send this to -bugs since it seems like an interesting error. The short version is that I have a table ("ways") which has a primary key ("id") th