Postgres Pro
Downloads
Home   >   mailing lists

BUG #2536: TInterval: wrong interpretation of "Undefined Range" value. - Mailing list pgsql-bugs

From Alexandr Sereda
Subject BUG #2536: TInterval: wrong interpretation of "Undefined Range" value.
Date
Msg-id 200607180741.k6I7fjWu024430@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2536
Logged by:          Alexandr Sereda
Email address:      click2002@ukr.net
PostgreSQL version: 7.4.9 - 8.1.4
Operating system:   FreeBSD, Linux, Windows Xp
Description:        TInterval: wrong interpretation of "Undefined Range"
value.
Details:

Then we store some values in tinterval fields, psql shows "Undefined Range".
Then we dumping table with these values, we receive same in dump. But, then
we wont to restore it back, we receive error.

TINTERVAL
====================================================
BASE                DUMP                OPERATION
----------------------------------------------------
UNDEFINED RANGE --> UNDEFINED RANGE     DUMPING OUT

UNDEFINED RANGE <-- INVALID             DUMPING IN
====================================================

pgsql-bugs by date:

Previous
From: "somas"
Date:
Subject: BUG #2537: PHP-Postgres connection fails
Next
From: "Andrew Hammond"
Date:
Subject: double insert on inherited table with where constraint based on sequence