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 по дате отправления: