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: 20080522175756.GA2266@depesz.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group