Re: [GENERAL] Creating indeces on existing tables...

[Hiroshi Inoue]

Steve Wolfe wrote: > > OK, one of my tables was getting duplicate entries, and I thought I'd > create a unique index on a particular field. So, I created the index: > > domains=# create unique index idx_domain_name on domain (domain_name); > CREATE > > Then, tried a vaccum: > > domains=# vacuum analyze; > NOTICE: Index idx_domain_name: NUMBER OF INDEX' TUPLES (305) IS NOT THE > SAME AS HEAP' (311). > Recreate the index. > VACUUM > This is a known bug. Probably there's a long transaction somewhere. It is fixed in 7.1. Regards, Hiroshi Inoue