From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql/src backend/access/transam/xact.c backen ... |
Date: | 2001-09-29 05:01:53 |
Message-ID: | 13996.1001739713@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
I'm seeing the following failure in the rules regress test:
$ diff expected/rules.out results
1338c1338
< shoelace_data | log_shoelace | CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data WHERE (new.sl_avail <> old.sl_avail) DO INSERT INTO shoelace_log (sl_name, sl_avail, log_who, log_when) VALUES (new.sl_name, new.sl_avail, 'Al Bundy'::name, 'Thu Jan 01 00:00:00 1970'::"timestamp");
---
> shoelace_data | log_shoelace | CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data WHERE (new.sl_avail <> old.sl_avail) DO INSERT INTO shoelace_log (sl_name, sl_avail, log_who, log_when) VALUES (new.sl_name, new.sl_avail, 'Al Bundy'::name, "timestamp"('epoch'::text));
$
The actual result corresponds to the former output, and is indeed what
I would expect, given that text_timestamp() is (and should be)
non-cachable. Are you sure this expected file is correct?
I'm also seeing rather massive failures in horology, but this evidently
is because horology-no-DST-before-1970.out hasn't been updated ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | tgl | 2001-09-29 05:11:11 | pgsql/src/test/regress/expected horology-no-DS ... |
Previous Message | tgl | 2001-09-29 04:02:29 | pgsql/ oc/src/sgml/wal.sgml rc/backend/access/ ... |