| From: | Jean-Christophe ARNU (JX) <arnu(at)paratronic(dot)fr> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_statistic_relid_att_index |
| Date: | 2003-06-25 09:53:36 |
| Message-ID: | 20030625115336.02689135.arnu@paratronic.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
--
Jean-Christophe ARNU
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2003-06-25 10:04:52 | Re: [GENERAL] interesting PHP/MySQL thread |
| Previous Message | Shridhar Daithankar | 2003-06-25 09:29:36 | Re: [GENERAL] Physical Database Configuration |