Re: Some timestamp problems - Mailing list pgsql-admin

From Jean-Luc Lachance
Subject Re: Some timestamp problems
Date
Msg-id 3D6E8139.86F67328@nsd.ca
Whole thread Raw
In response to Some timestamp problems  ("Vilson farias" <vilson.farias@digitro.com.br>)
List pgsql-admin
I think there is plenty of time to address the Y10K problem...  :)

JLL


Vilson farias wrote:
>
> Greetings,
>
>   I found some strange behaviour in 7.1.2. Is it the same thing on 7.2.2 ?
>
>   I don't know if it's a psql bug, but I would like to report it anyway
>
> bxs=# \d test2
>                      Table "test2"
>     Attribute     |           Type           | Modifier
> ------------------+--------------------------+----------
>  x                | integer                  |
>  apagar_menor_que | timestamp with time zone |
>
> bxs=# insert into test2 values(1, '2111-10-01 04:23:59.999');
> INSERT 259672 1
> bxs=# insert into test2 values(2, '20001-10-01 04:23:50');
> INSERT 259673 1
> bxs=# insert into test2 values(3, '20001-10-01 04:23:59');
> INSERT 259674 1
> bxs=# insert into test2 values(4, '20001-10-01 04:23:59.99');
> INSERT 259675 1
> bxs=# insert into test2 values(5, '20001-10-01 04:23:59.999');
> INSERT 259676 1
> bxs=# insert into test2 values(6, '20001-10-01 04:23:59.998');
> INSERT 259677 1
> bxs=# SELECT * FROM test2;
>  x |    apagar_menor_que
> ---+------------------------
>  1 | 2111-10-01 04:23:60.00
>  2 | 20001-10-01 04:2350
>  3 | 20001-10-01 04:2359
>  4 | 20001-10-01 04:2359.99
>  5 | 20001-10-01 04:2360.00
>  6 | 20001-10-01 04:2360.00
> (6 rows)
>
> bxs=#
>
> Best regards from Brazil,
>
> ----------------------------------------------------------------------------
> ----
> José Vilson de Mello de Farias
> Software Engineer
>
> Dígitro Tecnologia Ltda - www.digitro.com.br
> APC - Customer Oriented Applications
> E-mail: vilson.farias@digitro.com.br
> Tel.: +55 48 281 7158
> ICQ 11866179
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Interpretting WAL debug.
Next
From: "Tyler Mitchell"
Date:
Subject: Running postgres on a read-only file system