Re: Re: Bug with timestamp !!!

"Mitch Vincent" <mitch@venux.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