Re: [opennms-discuss] Timeoffset Incorrect on 1.14
2005-02-01 02:12:05 GMT
Jesus M. Salvo Jr. wrote: > DJ Gregor wrote: > >> There is some history to this, and it looks like I might have goofed >> when I switched the data type in the table definitions to "timestamp >> without time zone" from "timestamp". >> >> The table definitions used to say just "timestamp", however this is >> interpreted differently starting with PostgreSQL 7.3. Prior to 7.3, >> "timestamp" meant "timestamp with time zone" and starting with >> PostgreSQL 7.3 "timestamp" mean "timestamp without time zone". >> >> The way I think it currently works is that the time is stored in the >> local time. I don't know why you'd see the one hour difference. >> >> Please open up a bug (http://bugzilla.opennms.org/) and assign it to >> me (dj <at> opennms.org) and I'll take a closer look at this problem. >> Please include as many details as possible, including the information >> you initially sent to the list, as well as your time zone and your >> offset from the time zone. > > > > I have opened a bug for this one: > > http://bugzilla.opennms.org/cgi-bin/bugzilla/show_bug.cgi?id=1079 > > The important thing to note I guess is that looking at a specific > event, the value of the "eventcreatetime" column is actually correct,(Continue reading)
RSS Feed