which index? could you help me again? Eric Anderson Martins Miranda Net Admin @ Via Net SAO ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 8:50 PM Subject: Re: [SQL] yet pg_toast reindex
> "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
