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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~