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
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 |