From: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: discover a toast table name
Date: Tue, 27 May 2003 12:34:23 -0300
Message-ID: <01cd01c32465$7356c8b0$0701a8c0@netterm> (raw)
References: <001101c31fb8$ebdb30c0$0701a8c0@netterm>
<3ECE195A.7060209@Yahoo.com>
<004901c3212e$8919fda0$0701a8c0@netterm>
<3ECFE017.7060800@Yahoo.com>
<00e001c32453$2f8f45b0$0701a8c0@netterm>
<15000.1054045212@sss.pgh.pa.us>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eric@vianet-express.com.br, tgl@sss.pgh.pa.us
Subject: Re: discover a toast table name
In-Reply-To: <01cd01c32465$7356c8b0$0701a8c0@netterm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox