Re: [GENERAL] \di won't display indexes - Mailing list pgsql-general

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@chipcastle.com    http://www.chipcastle.com
> 504.412.8002        Perl CGI MySQL E-commerce
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ************
>
>


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