Re: Multiple table entries? - Mailing list pgsql-general

From Jeff Ross
Subject Re: Multiple table entries?
Date
Msg-id 4A90B17E.7040506@wykids.org
Whole thread Raw
In response to Re: Multiple table entries?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark wrote:
> On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross<jross@wykids.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


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: join from array or cursor
Next
From: Jeff Ross
Date:
Subject: Re: Multiple table entries?