Обсуждение: \di won't display indexes
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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