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(dot)Rudow(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~