Re: Failed regression tests with 7.0.3 on Windows NT 4.0

Christian Ullrich <chris(at)chrullrich(dot)de> writes:
> I've just gotten PostgreSQL 7.0.3 to build and actually run under
> WinNT 4.0, and the regression tests show two problems: one probably
> minor in horology (I suppose there's a wrong time zone somewhere), and
> one probably major in alter_table. I attached the diff output.

The horology discrepancy looks like WinNT doesn't have daylight-savings
info before 1970. Try adding
horology/.*-cygwin=horology-no-DST-before-1970
to src/test/regress/resultmap. (I see this has already been done in
current sources.)

> ALTER TABLE tenk1 RENAME TO ten_k;
> + ERROR: renamerel: unable to rename tenk1.1 to ten_k.1: error 0

Apparently a cygwin bug? Evidently rename() forgets to set errno on
failure. renamerel() is expecting to see errno = ENOENT when the file
to be renamed doesn't exist.

This is irrelevant for 7.1, since we don't try to do physical file
renames anymore. If you can live without ALTER TABLE RENAME for awhile
then you could just put up with it for now. Otherwise, pester the
cygwin folk to fix rename().

regards, tom lane