Andrew Snow <[EMAIL PROTECTED]> writes:
> Here's a simpler script which reproduces the bug:
OK, I can reproduce the bug in 7.0.2 and 7.0.3, but not in current
development sources. More tomorrow ... I'm about out of steam
for tonight ...
regards, tom lane
> Looks like a bug to me, but I'd like not to have to reverse-engineer the
> test case before I can look at it. Could you provide some sample data,
> as well as the missing "Types" table declaration? Ideally a psql script
> file to load everything up from scratch and trigger the error ;-)
Well
Andrew Snow <[EMAIL PROTECTED]> writes:
> # select * from mailredirs where start < CURRENT_TIMESTAMP and stop >
>CURRENT_TIMESTAMP;
> ERROR: Bad timestamp external representation 'Just because.'
> Why is it even looking at the 'reason' field??
Looks like a bug to me, but I'd like not to have t
Further to this, I wish you to note the following works correctly:
# select start, stop from mailredirs where start < CURRENT_TIMESTAMP;
start | stop
+
2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11
(1 row)
# select st
I just installed v7.0.3 release on a FreeBSD 4.x system. (Problem still happened in
7.0.2 too).
This is the problem I noticed:
# select * from mailredirs;
username |destination | start | stop |
reason
--++