Re: pg_statistic_relid_att_index - Mailing list pgsql-general

From Jean-Christophe ARNU (JX)
Subject Re: pg_statistic_relid_att_index
Date
Msg-id 20030625115336.02689135.arnu@paratronic.fr
Whole thread Raw
In response to Re: pg_statistic_relid_att_index  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: pg_statistic_relid_att_index  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Le Wed, 25 Jun 2003 03:25:46 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com> me disait que :

> Drop and recreate the index is your only solution given the constraints
> you have.
>

    Thanks for your quick answer. :)

    I agree on this procedure to get rid of the reluctant indices  but as
pg_statistic_relid_att_index is a system index it seems to put another problem
in the bucket :   An error occurs when I try to remove this index....

supervisor=# drop index pg_statistic_relid_att_index;
ERROR:  index "pg_statistic_relid_att_index" is a system index

    If I try to do the same on template1 database, I get the same result :/


    Regards

--
Jean-Christophe ARNU

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: pg_statistic_relid_att_index
Next
From: Justin Clift
Date:
Subject: Re: [pgsql-advocacy] interesting PHP/MySQL thread