Re: discover a toast table name

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" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
Cc: <pgsql-sql(at)postgresql(dot)org>
Sent: Tuesday, May 27, 2003 11:20 AM
Subject: Re: [SQL] discover a toast table name

> "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br> 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 majordomo(at)postgresql(dot)org)