Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
REINDEX TABLE pg_toast.pg_toast_16429;

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


In response to


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group