[GENERAL] Creating indeces on existing tables...

2001-01-31 Thread Steve Wolfe
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_domai

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

2001-01-31 Thread 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=# vac