Thank to everybody, I recompiled Postgres and tested it on the same DB : the offending
SELECT worked, without any index regeneration. Maybe the order in which the items
where inserted in the table (using COPY, before creating the index) made it working.
I only had problems with the source RPMs :
On Fri, Jan 28, 2000 at 01:41:52PM -0600, [EMAIL PROTECTED] wrote:
> Occasionally a question is posted to this list that is not a question
> about postgres, but to which I know the answer. When this happens, I
> usually reply only to the person who posted the question, rather than to
> the whole
Occasionally a question is posted to this list
that is not a question about postgres, but to which I know the answer.
When this happens, I usually reply only to the person who posted the question,
rather than to the whole list. I do this to minimize non-postgres traffic
on the list. Howe
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Hiroshi neglected to mention that you'd probably need to drop and
> >> recreate the index after applying the patch; if it's indeed out of
> >> order, just patching the comparator bug isn't enough to fix it.
>
> > Does Hiroshi's patch get applied?
>
Applied.
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Nicolas Huillard
> >
> > I have a DB with is updated using MS Access. Primary keys are
> > Int4 with default random values ("Num_
"Jackson, Kevin J." wrote:
>
> 1) What does the following mean:
> PostgresSQL query failed: ERROR: Bad date external representation
You might have an illegal date string format, though this kind of
message also shows up in other circumstances IIRC.
Try 'MM/DD/' or '-MM-DD'...
> 2) Is
I have downloaded the postgres binaries for windows nt.
Could somebody tell me how to start initdb.
Also i had install cygnus20b but i can't do nothing with this.
On Linux everything it's ok, but on nt i'm stacked.
Using Access 97 I have a Database field defined as a time stamp being
pulled in as a data type of date/time which is correct. My problem is that
I now what to add some criteria to select it and have tried both the
criteria of Date()-1 which results in an empty set, and createing a new
field
