Re: [BUGS] BUG #5912: Etc/GMT time utc offset error

2011-03-03 Thread Tom Lane
"Ross Williams" writes: > On the target OS the offsets are correct GMT+ gives a increased utc_offset. > When I attempt to set via postgres, the timezone are flipped + for - and > vice versa. The problem is that there are conflicting standards for the sign of UTC offsets. The conventions Postgres

[BUGS] BUG #5912: Etc/GMT time utc offset error

2011-03-03 Thread Ross Williams
The following bug has been logged online: Bug reference: 5912 Logged by: Ross Williams Email address: ross.willi...@watchguard.com PostgreSQL version: 8.3.1 and 8.4.7 Operating system: FreeBSD 7.3 and Ubuntu 10 Description:Etc/GMT time utc offset error Details: On t