Skip site navigation (1) Skip section navigation (2)

Re: BUG #4317: problem with comparision of datatypedate

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Sanjay Rajdev" <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4317: problem with comparision of datatypedate
Date: 2008-07-18 19:51:35
Message-ID: 4880AE60.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
>>> On Fri, Jul 18, 2008 at  2:35 PM, in message
<4744486(dot)108381216409720544(dot)JavaMail(dot)root(at)mail(dot)featherstoneinformatics(dot)com>,
Sanjay Rajdev <sanjay(dot)rajdev(at)featherstoneinformatics(dot)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

In response to

pgsql-bugs by date

Next:From: C├ędric VillemainDate: 2008-07-21 08:16:02
Subject: winsock error 10004
Previous:From: Sanjay RajdevDate: 2008-07-18 19:35:20
Subject: Re: BUG #4317: problem with comparision of datatype date

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group