Re: BUG #4317: problem with comparision of datatype date - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #4317: problem with comparision of datatype date
Date
Msg-id 4880AE60.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: BUG #4317: problem with comparision of datatype date  (Sanjay Rajdev <sanjay.rajdev@featherstoneinformatics.com>)
List pgsql-bugs
>>> On Fri, Jul 18, 2008 at  2:35 PM, in message
<4744486.108381216409720544.JavaMail.root@mail.featherstoneinformatics.com>,
Sanjay Rajdev <sanjay.rajdev@featherstoneinformatics.com> wrote:

> Thanks for the thought, I think that this can be the problem, as
earlier
> 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
been
> noticed after the index's were added.
> I can't test this out as this happens while people are using the
software,

Try adding another index on the column (with a different index name)
using CREATE INDEX CONCURRENTLY.  Then drop the old index.

-Kevin

pgsql-bugs by date:

Previous
From: Sanjay Rajdev
Date:
Subject: Re: BUG #4317: problem with comparision of datatype date
Next
From: Cédric Villemain
Date:
Subject: winsock error 10004