Re: Multiple table entries?

From: Jeff Ross <jross(at)wykids(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple table entries?
Date: 2009-08-23 03:03:26
Message-ID: 4A90B17E.7040506@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
> On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross<jross(at)wykids(dot)org> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Ross 2009-08-23 03:06:29 Re: Multiple table entries?
Previous Message Greg Stark 2009-08-23 02:36:09 Re: join from array or cursor