Re: need a bit of help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Warren Little <warren(dot)little(at)meridiascapital(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: need a bit of help
Date: 2006-04-26 23:22:26
Message-ID: 22837.1146093746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Warren Little <warren(dot)little(at)meridiascapital(dot)com> writes:
> which appears to be the pg_toast entry. Shouldn't there be a pg_class
> whose reltoastrelid equals the reltoastidxid of the pg_toast instance

No. The deal is

regular table's reltoastrelid points to OID of its toast table

toast table's reltoastidxid points to OID of its index

There's no "back links".

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Warren Little 2006-04-26 23:46:58 Re: need a bit of help
Previous Message Jim C. Nasby 2006-04-26 22:52:01 Re: Table partitioning