[Rt-devel] 3.4.5: redundant users1 and users2 indexes.

[Jesse Vincent]

On Thu, Apr 20, 2006 at 06:46:29PM -0400, Dmitri Tikhonov wrote:
> Dear RT Developers:
> 
> my RT is a stock FC5 3.4.5 with PostgresSQL as backend.  Poking around
> the schema, I've noticed two redundant indexes:
> 
> Indexes:
>     "users_pkey" PRIMARY KEY, btree (id)
>     "users1" UNIQUE, btree (name)
>     "users2" btree (name)
> 
> That seemed strange to me, so off to the mailing list archive I went,
> only to discover that this had already been discussed one and a half
> years ago:
> 
> http://lists.bestpractical.com/pipermail/rt-devel/2004-September/006274.html
> 
> Why did not it make it into 3.2.2 (or why isn't it in 3.4.5)?

I have no idea. The easiest thing is likely to fix it in the 3.6.0
database upgrade scripts.

> Sincerely,
> 
>   - Dmitri.
> 
> 
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> 
> Best Practical is hiring! Come hack Perl for us: http://bestpractical.com/about/jobs.html
> 

--