Re: Index problem...

Поиск
Список
Период
Сортировка
От Carol Walter
Тема Re: Index problem...
Дата
Msg-id 3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu
обсуждение исходный текст
Ответ на Re: Index problem...  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: Index problem...  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Index problem...
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Index problem...