Search Postgresql Archives

Re: Multiple table entries?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greg Stark wrote:
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross<jross@xxxxxxxxxx> wrote:
Hi,

I recently upgraded to 8.4 and everything went great. �All databases are
working as they are supposed to, no problems seen.

Today, however, I did a \d on a database and was surprised to see sets of 5
identical table entries for each one that is supposed to be there.

Ugh.

What does

select xmin,xmax,ctid,oid,* from pg_class

return?

216 rows worth, but I only see one entry per table, not 5.

For easier reading, I put the output at

   http://openvistas.net/pg_class_query.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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux