Re: pg_statistic_relid_att_index

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: pg_statistic_relid_att_index
Дата
Msg-id Pine.LNX.4.33.0306250413550.30378-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: pg_statistic_relid_att_index  (Jean-Christophe ARNU (JX) <arnu@paratronic.fr>)
Ответы Re: pg_statistic_relid_att_index  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: [pgsql-advocacy] interesting PHP/MySQL thread
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: pg_statistic_relid_att_index