Question about Postgresql time fields(possible bug)

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Question about Postgresql time fields(possible bug)
Date: 2006-01-10 15:38:11
Message-ID: 43C3D4E3.9040708@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I just noticed today that Postgresql accepts a value of 24:00:00, this
is for sure not correct as there is no such thing as 24:00:00

PG Admin III will display this value just fine which is also incorrect,
PG Lightning Admin catches it as a invalid time, but shouldn't there be
some validation of times and dates at the server level?

There are people who are using PG Admin III and they don't even know
they have bogus dates and times in their databases.

Thanks,

Tony

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-01-10 15:51:49 Re: Question about Postgresql time fields(possible bug)
Previous Message Neil Conway 2006-01-10 15:30:41 Re: lookup_rowtype_tupdesc considered harmful