>>> On Fri, Jul 18, 2008 at 2:35 PM, in message
Sanjay Rajdev <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com> wrote:
> Thanks for the thought, I think that this can be the problem, as
> there was no indexing on the column, but 2 days back we added index
on 5 of
> columns in the table and "somedate" is one of them. This problem have
> noticed after the index's were added.
> I can't test this out as this happens while people are using the
Try adding another index on the column (with a different index name)
using CREATE INDEX CONCURRENTLY. Then drop the old index.
In response to
pgsql-bugs by date
|Next:||From: Cédric Villemain||Date: 2008-07-21 08:16:02|
|Subject: winsock error 10004|
|Previous:||From: Sanjay Rajdev||Date: 2008-07-18 19:35:20|
|Subject: Re: BUG #4317: problem with comparision of datatype date|