Re: Creating indeces on existing tables...

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Steve Wolfe <steve(at)iboats(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating indeces on existing tables...
Date: 2001-01-31 23:14:54
Message-ID: 3A789C6E.F1DB34F2@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-01-31 23:27:18 Re: trying to back up a database
Previous Message Dan Wilson 2001-01-31 22:39:46 Re: Re: grant privileges to a database