Re: pg_statistic_relid_att_index

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Jean-Christophe ARNU <arnu(at)paratronic(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_statistic_relid_att_index
Date: 2003-06-25 10:14:10
Message-ID: Pine.LNX.4.33.0306250413550.30378-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)marlowe(at)ihs(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-06-25 10:46:49 Re: pg_statistic_relid_att_index
Previous Message Justin Clift 2003-06-25 10:04:52 Re: [GENERAL] interesting PHP/MySQL thread