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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~