From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Maciek Sakrejda <maciek(at)heroku(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8656: Duplicate data violating unique constraints |
Date: | 2013-12-06 10:07:51 |
Message-ID: | 20131206100751.GJ7814@awork2.anarazel.de |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2013-12-05 17:21:04 -0800, Maciek Sakrejda wrote:
> On Thu, Dec 5, 2013 at 1:15 AM, Andres Freund <andres(at)2ndquadrant(dot)com>wrote:
> The original data has been deleted, but I did manage to do PITR to a point
> that exhibits the issue:
Cool..
> => with affected_pages as (
> select distinct regexp_replace(ctid::text, '\((\d+),\d+\)', '\1') as page
> from post where id in (select id from post group by id having count(*) >
> 1)
> ) select page_header(get_raw_page('post', page::integer)) from
> affected_pages;
Hm, could you rewrite that to:
...
select * FROM affectec_pages, page_header(get_raw_page('post', page::integer));
That should work in 9.3 and will give us a much more readable result.
> => with affected_pages as (
> select distinct regexp_replace(ctid::text, '\((\d+),\d+\)', '\1') as page
> from post where id in (select id from post group by id having count(*) >
> 1)
> ) select heap_page_items(get_raw_page('post', page::integer)) from
> affected_pages;
Same here.
Thanks!
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Vitaly Tskhovrebov | 2013-12-06 12:21:39 | Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs |
Previous Message | Magnus Hagander | 2013-12-06 09:18:02 | Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs |