Re: Re: Bug with timestamp !!!

"Mitch Vincent" <mitch(at)venux(dot)net> writes:
> ipa=# select version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.1.1 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2

Is that really the release version, or a prerelease? (To be specific,
do you have v 1.49 of src/backend/utils/adt/timestamp.c?)

> ipa=# insert into tmp values('2001-04-01 02:29:52');

If you live in the USA, 4/1 was a DST transition day: there is no such
time as 2:29 AM local time. Some C libraries cope with this better than
others. We made some last-minute patches in 7.1.1 that are intended to
work around the less-well-behaved libraries, and I'm wondering whether
you have 'em.

regards, tom lane