Re: [GENERAL] Error creating index (v6.5)

Roberto Moreda wrote:

> sanluis=> CREATE INDEX art_idx2 ON ARTICULOINFO (shFamilia);
> FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>                 before or while processing the request.
>                 We have lost the connection to the backend, so further
> processing is impossible.  Terminating.

> What happens?

have you inserted a large amount of data before ?
probably using copy ?
then try vacuum.

If that doesnt help try copying your data out, recreating table and
copying back in.
And don't forget to vacuum.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow                 E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services    Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~