From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Jean-Christophe ARNU <arnu(at)paratronic(dot)fr>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_statistic_relid_att_index |
Date: | 2003-06-25 10:46:49 |
Message-ID: | 20030625104649.GA30780@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jun 25, 2003 at 04:14:10AM -0600, scott.marlowe wrote:
> Looks like you'll have to dump and restore your database. :-(
Nothing so drastic. 7.1 has reindex (7.0 has to 7.1 must have it too). To do
it on system indexes you need to run it as single user mode. Start the
a postgres process with -P which allows you to reindex system indexes.
Probably drop them too, if you want to.
> 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
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-06-25 10:54:25 | Re: Updating an emty table? |
Previous Message | scott.marlowe | 2003-06-25 10:14:10 | Re: pg_statistic_relid_att_index |