pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (6+ messages)  latest in thread

Message-ID: <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu>
Permalink:  ../3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu/
Also on:    postgresql.org/message-id/3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu

 · 

reply

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