Re: yet pg_toast reindex

Поиск
Список
Период
Сортировка
От Eric Anderson Vianet SAO
Тема Re: yet pg_toast reindex
Дата
Msg-id 00a001c33596$9cc1a9d0$0701a8c0@netterm
обсуждение исходный текст
Ответ на Re: select date range?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-sql
which index? could you help me again?

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, June 17, 2003 8:50 PM
Subject: Re: [SQL] yet pg_toast reindex


> "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> > Sorry about this sucks thread but now i´v got following error
> > ERROR: relation "pg_toast_26474986" is of type "t"
>
> You may have to use REINDEX INDEX (on the index not the toast table of
> course) to get it to work in older versions.  REINDEX didn't use to
> think it could work on toast tables.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html



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

Предыдущее
От: "Rudi Starcevic"
Дата:
Сообщение: Text insert max. size.
Следующее
От: Tm
Дата:
Сообщение: Re: Object-Relational table design question