I have just found a bug in 6.5.1
>vacuum;
NOTICE: BlowawayRelationBuffers(search_url, 5): block 106 is referenced (private 0, last 0, global 1)
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.
>vacuum;
NOTICE: Index search_url_refnum_key: NUMBER OF INDEX' TUPLES (96) IS NOT THE SAME AS HEAP' (192)
ERROR: Cannot insert a duplicate key into a unique index
>vacuum
NOTICE: CreatePortal: portal <vacuum> already exists
NOTICE: Index search_url_refnum_key: NUMBER OF INDEX' TUPLES (96) IS NOT THE SAME AS HEAP' (192)
ERROR: Cannot insert a duplicate key into a unique index
Looks like I cant vacuum my database any more.
M Simms