"Kevin O'Gorman" <kogorman@pacbell.net> writes:
> so I tried going back to '7 Oct 2000 10:00:00 PST' and it's better,
> but regression tests fail on the rule system. It makes the server
> die. Since rules are what I want, this won't do.
Details? AFAIK, the system was operational on 7-Oct; I did not pick
that date out of the air. There was a broken version of the
expected/rules.out file in place right around then --- see
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out
But that'd just have caused a bogus comparison failure, not a server
crash. (What was *in the expected file* was a report of a server
crash :-(, so if you didn't look carefully at the diff you might've
gotten confused...)
If you want a more exact timestamp, try 7-Oct-2000 00:00 PDT which
predates the BEOS patch breakage, or 8-Oct-2000 00:00 PDT which follows
cleanup. If either of those fail on your system it'd be useful to know
about.
regards, tom lane