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