Re: pg_statistic_relid_att_index - Mailing list pgsql-general

From scott.marlowe
Subject Re: pg_statistic_relid_att_index
Date
Msg-id Pine.LNX.4.33.0306250413550.30378-100000@css120.ihs.com
Whole thread Raw
In response to Re: pg_statistic_relid_att_index  (Jean-Christophe ARNU (JX) <arnu@paratronic.fr>)
Responses Re: pg_statistic_relid_att_index  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Looks like you'll have to dump and restore your database.  :-(

On Wed, 25 Jun 2003, Jean-Christophe ARNU wrote:

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


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: [pgsql-advocacy] interesting PHP/MySQL thread
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pg_statistic_relid_att_index