From: hubert depesz lubaczewski <depesz@depesz.com>
To: Carol Walter <walterc@indiana.edu>
Cc: Tomeh, Husam <HTomeh@facorelogic.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Index problem...
Date: Thu, 22 May 2008 19:57:56 +0200
Message-ID: <20080522175756.GA2266@depesz.com> (raw)
In-Reply-To: <76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu>
References: <473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu>
<F1B0F9305B343E43A1C3EECE48B853D501A847B9@CITGSNA01SXCH02.ana.firstamdata.com>
<76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: depesz@depesz.com, walterc@indiana.edu, HTomeh@facorelogic.com
Subject: Re: Index problem...
In-Reply-To: <20080522175756.GA2266@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox