Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

2010-03-02 Thread Kevin Grittner
Robert Haas wrote: Vitali wrote: When I select from the table, the timetz has the correct time zone, the timestamptz has -6 as a time zone, which is my server default. I'm not sure what you think the bug is, but timestamptz definitely doesn't store the time zone in which the value is

Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

2010-03-02 Thread Vitali Malinouski
:35:32 AM Subject: Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone Robert Haas wrote: Vitali wrote: When I select from the table, the timetz has the correct time zone, the timestamptz has -6 as a time zone, which is my server default. I'm not sure what you

Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

2010-03-02 Thread Bruce Momjian
Message - From: Kevin Grittner kevin.gritt...@wicourts.gov To: robertmh...@gmail.com, vit...@lumensoftware.com Cc: pgsql-bugs@postgresql.org Sent: Tuesday, March 2, 2010 7:35:32 AM Subject: Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone Robert Haas wrote: Vitali

[BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

2010-03-01 Thread Vitali
The following bug has been logged online: Bug reference: 5354 Logged by: Vitali Email address: vit...@lumensoftware.com PostgreSQL version: 8.1.x 8.2.x Operating system: Windows, Linux Description:Type timestamptz doesn't allow to store time zone Details: I have a

Re: [BUGS] BUG #5354: Type timestamptz doesn't allow to store time zone

2010-03-01 Thread Robert Haas
On Mon, Mar 1, 2010 at 10:52 AM, Vitali vit...@lumensoftware.com wrote: The following bug has been logged online: Bug reference:      5354 Logged by:          Vitali Email address:      vit...@lumensoftware.com PostgreSQL version: 8.1.x 8.2.x Operating system:   Windows, Linux