when i try that i´v got an error ERROR: "pg_toast_26474986" is a system table. call REINDEX under standalone postgres with -O -P options
so I kill postmaster and up it standalone. but the reindex command doesn´t have options. and postmaster doesn´t have these ones too. tnx. 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, May 27, 2003 11:20 AM Subject: Re: [SQL] discover a toast table name > "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> writes: > > How can I discover which toast table referenced to a phisic table? > > Look at the base table's pg_class row. reltoastrelid is the OID of the > corresponding toast table. So, for example, if I thought "text_tbl" had > such a problem: > > regression=# select relname from pg_class where > regression-# oid = (select reltoastrelid from pg_class where relname = 'text_tbl'); > relname > ----------------- > pg_toast_163219 > (1 row) > > regression=# reindex table pg_toast.pg_toast_163219; > REINDEX > regression=# > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
