Re: [GENERAL] URGENT: Index problems

2001-10-17 Thread Steve Brett
# verify we still have data... diff before after# quick sanity check... will let you know if it works ... "Steve Brett" <[EMAIL PROTECTED]> wrote in message 9qjgpp$3h3$[EMAIL PROTECTED]">news:9qjgpp$3h3$[EMAIL PROTECTED]... > I a

Re: [GENERAL] URGENT: Index problems - update - please help ....

2001-10-17 Thread Steve Brett
okay. i followed the instructions very carefully and get the following error when i try to run pg_upgrade .. Cannot find database template1 in ./data/base. Are you running ./pg_upgrade as the postgres superuser? i am running as superuser and template1 is not there. Steve "Steve

[GENERAL] URGENT: Index problems

2001-10-17 Thread Steve Brett
I added a hash index to a varchar value and when i vacuumed i got the following error: Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS HEAP' (9181). dropping and recreating the index gave me the same error (on this index only) dropping the database and reimporting the