Matthew Braithwaite <mab-lists@braithwaite.net> writes:
> I RTFM but I'm still confused. I have a table, headers
>> mab=> \d headers
>> Table "headers"
>> Attribute | Type | Modifier
>> -----------+---------+---------------------------------------------------------
>> header_id | integer | not null default nextval('headers_header_id_seq'::text)
>> part_id | integer | not null
>> key | text |
>> value | text |
>> Index: headers_pkey
> I have indexed the table by part_id:
>> mab=> \d headers_ref_idx
>> Index "headers_ref_idx"
>> Attribute | Type
>> -----------+---------
>> part_id | integer
>> btree
Um, it sure looks like that index is not on that table. Note that the
"\d headers" output shows only one index, named headers_pkey.
regards, tom lane
