Re: [ADMIN] need a bit of help

2006-04-26 Thread Warren Little
ok thanks On Wed, 2006-04-26 at 19:22 -0400, Tom Lane wrote: > Warren Little <[EMAIL PROTECTED]> 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

Re: [ADMIN] need a bit of help

2006-04-26 Thread Tom Lane
Warren Little <[EMAIL PROTECTED]> 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 p

[ADMIN] need a bit of help

2006-04-26 Thread Warren Little
Hello, got myself in a pickle with the database running out of space. I have a question regarding pg_toast tables and their relationships to the parent tables. If I run the following query select * from pg_class where reltoastrelid like '%944' or reltoastidxid like '%944' I receive a single row