From: Carol Walter <walterc@indiana.edu>
To: depesz@depesz.com
Cc: Tomeh, Husam <HTomeh@facorelogic.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Index problem...
Date: Thu, 22 May 2008 15:41:38 -0400
Message-ID: <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu> (raw)
In-Reply-To: <20080522175756.GA2266@depesz.com>
References: <473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu>
<F1B0F9305B343E43A1C3EECE48B853D501A847B9@CITGSNA01SXCH02.ana.firstamdata.com>
<76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu>
<20080522175756.GA2266@depesz.com>
This gives the same error. I can select columns from the table
although select * gets the error. I tried making a copy of the
"maps" table using CREATE TABLE new table name (all columns) AS
SELECT all columns FROM maps; This also gave me the same error.
Carol
On May 22, 2008, at 1:57 PM, hubert depesz lubaczewski wrote:
> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: walterc@indiana.edu, depesz@depesz.com, HTomeh@facorelogic.com
Subject: Re: Index problem...
In-Reply-To: <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu>
References: <473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu> <F1B0F9305B343E43A1C3EECE48B853D501A847B9@CITGSNA01SXCH02.ana.firstamdata.com> <76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu> <20080522175756.GA2266@depesz.com> <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu>
* 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