"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