From: | Jacek Kalinski <jacek_kal(at)o2(dot)pl> |
---|---|
To: | Jonas Lindholm <jlhm(at)usa(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Daylight saving bug in PostgreSQL 7.2.1 ? |
Date: | 2003-07-12 07:04:08 |
Message-ID: | 3F0FB2E8.1020906@o2.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Dnia 07/12/2003 04:54 AM, Jonas Lindholm napisał(a):
> Hi!
>
> I believe I've found a bug with daylight saving time.
> The example below shows that after inserting a row with a date and time
> when daylight saving is changing (6 April 2003 02:00:00) any selects
> using the same time and date are only returning correct result first
> time. If the select is done again the row is not found.
Hi,
I had similar problem that select returned 1 or 0 rows (with the same
query) (if you want - see "SELECT bug?")
I don't know where is the problem, but try to reindex table timespan.
In my database it resolved all problems (hope so ;) )
Now select return correct values.
Jacek
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-12 20:56:27 | Re: Daylight saving bug in PostgreSQL 7.2.1 ? |
Previous Message | Jonas Lindholm | 2003-07-12 02:54:50 | Daylight saving bug in PostgreSQL 7.2.1 ? |