Re: Index problem...

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: "Tomeh, Husam" <HTomeh(at)facorelogic(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Index problem...
Date: 2008-05-22 17:57:56
Message-ID: 20080522175756.GA2266@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote:
> When I ran the query you specified I got relname of "pg_toast_16429.
> When I ran the REINDEX TABLE pg_toast_16429 the system responds that
> relation "pg_toast_16429" does not exist.

I think it should be pg_toast.pg_toast_16429
so:
REINDEX TABLE pg_toast.pg_toast_16429;

check relnamespace in pg_class for this table, and check it against
pg_namespace to be sure.

depesz

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-05-22 19:41:38 Re: Index problem...
Previous Message Carol Walter 2008-05-22 17:37:56 Re: Index problem...