On Sun, Aug 23, 2009 at 4:06 AM, Jeff Ross<jross(at)wykids(dot)org> wrote:
> Greg Stark wrote:
>> Actually, I wonder if this isn't more likely to show the problem -- it
>> would explain why *all* your tables are showing up with duplicates
>> rather than just one.
>>
>> select xmin,xmax,ctid,oid,* from pg_namespace
>
> http://openvistas.net/pg_namespace_query.html
Yeah, that's a problem. Would you be able to load the pageinspect
contrib module and run a query?
select (h).* from (select
heap_page_items(get_raw_page('pg_namespace',0)) as h from p) as x;
--
greg
http://mit.edu/~gsstark/resume.pdf