On Sun, Aug 23, 2009 at 4:06 AM, Jeff Ross<jross@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
