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