Re: need a bit of help - Mailing list pgsql-admin

From Tom Lane
Subject Re: need a bit of help
Date
Msg-id 22837.1146093746@sss.pgh.pa.us
Whole thread Raw
In response to need a bit of help  (Warren Little <warren.little@meridiascapital.com>)
Responses Re: need a bit of help
List pgsql-admin
Warren Little <warren.little@meridiascapital.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

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Table partitioning
Next
From: Warren Little
Date:
Subject: Re: need a bit of help