Greg Stark wrote:
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;
I had to modify your query slightly to make it run--hope I got what you
are after!
select (h).* from (select
heap_page_items(get_raw_page('pg_namespace',0)) as h) as x;
http://www.openvistas.net/pageinspect.html
Thanks,
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
