Re: [GENERAL] \di won't display indexes

My guess is that you lost the pg_shadow entry for the users owning the
tables?

> Hello,
>
> The following psql transcript shows that \di and \ds commands do not
> show output, but that specifying a table explicitly (av_parts for
> example) does show the layout of my table as well as the indexes I
> expected to see. To make matters more confusing, my queries are
> extremely slow, so it appears that the indexes actually DO NOT EXIST.
>
> My Questions:
> How can I get the \di and \ds options to work?
> How do I verify that the indexes do exist?
>
> BTW: We're running PostGres 6.5.3
>
> =========================================================
>
> parts=> \di
> Couldn't find any indices!
> parts=> \ds
> Couldn't find any sequences!
> parts=> \d
> Couldn't find any tables, sequences or indices!
> parts=> \d av_parts
>
> Table = av_parts
> +----------------------------------+----------------------------------+-------+
> | Field | Type |
> Length|
> +----------------------------------+----------------------------------+-------+
> | itemid | int4 not null default nextval (
> | 4 |
> | vendorid | int4
> | 4 |
> | partnumber | varchar()
> | 25 |
> | alternatepartnumber | varchar()
> | 25 |
> | nsn | varchar()
> | 15 |
> | description | varchar()
> | 50 |
> | condition | varchar()
> | 10 |
> | quantity | int4
> | 4 |
> | rawpartnumber | varchar()
> | 25 |
> | rawalternatenumber | varchar()
> | 25 |
> | rawnsnnumber | varchar()
> | 15 |
> | date | int4
> | 4 |
> | cagecode | varchar()
> | 10 |
> +----------------------------------+----------------------------------+-------+
> Indices: av_parts_alternatepartnumber_in
> av_parts_itemid_key
> av_parts_nsn_index
> av_parts_partnumber_index
> av_parts_rawalternatenumber_ind
> av_parts_rawnsnnumber_index
> av_parts_rawpartnumber_index
> av_parts_vendorid_index
> parts=>
>
> ==============================================================================
> Thanks!
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Chip Castle Chip Castle Dot Com, Inc.
> chip(at)chipcastle(dot)com http://www.chipcastle.com
> 504.412.8002 Perl CGI MySQL E-commerce
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026