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

2010-03-02 Thread Bruce Momjian
27;t see how we can change it. --- > - Original Message - From: "Kevin Grittner" > 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

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

2010-03-02 Thread Vitali Malinouski
ubject: 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. > &

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 v

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 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 > Description:        Type ti

[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 t