Re: Timestamps and PostgreSQL

2010-12-06 Thread Paul Hoadley
Hi Andrew, On 07/12/2010, at 9:21 AM, Andrew Lindesay wrote: > Possibly not helpful, but you can stick this construct inside the class; > > static > { > ... do stuff ... > } > > I guess that runs before main() because it has to initialise the class before > it can run code in it. Actually, t

Re: Timestamps and PostgreSQL

2010-12-06 Thread Paul Hoadley
On 07/12/2010, at 9:16 AM, Chuck Hill wrote: > On Dec 6, 2010, at 2:10 PM, Paul Hoadley wrote: > >> On 07/12/2010, at 6:13 AM, Chuck Hill wrote: >> >>> Is there a Wiki page for EOF and Postgres? It strikes me as this is >>> something that should be documented. I don't think we can "fix" it,

Re: Timestamps and PostgreSQL

2010-12-06 Thread Paul Hoadley
On 07/12/2010, at 9:10 AM, Ramsey Gurley wrote: > I might be mistaken, but I don't think you can get any earlier than main(): > > public static void main(String argv[]) { > TimeZone.setDefault(...); > ERXApplication.main(argv, Application.class); > } That does work. -- Paul. http

Re: Timestamps and PostgreSQL

2010-12-06 Thread Ramsey Gurley
Oh yeah... static initializers and variables come first. D'oh! I think Chuck made an excellent point too. If that turns out to be the case, I think there's room for one last EOF commandment (Thou shalt not /Library/Java/Extensions) Ramsey On Dec 6, 2010, at 5:51 PM, Andrew Lindesay wrote:

Re: Timestamps and PostgreSQL

2010-12-06 Thread Andrew Lindesay
Hi Ramsey; Possibly not helpful, but you can stick this construct inside the class; static { ... do stuff ... } I guess that runs before main() because it has to initialise the class before it can run code in it. cheers. I might be mistaken, but I don't think you can get any earlier than

Re: Timestamps and PostgreSQL

2010-12-06 Thread Chuck Hill
On Dec 6, 2010, at 2:10 PM, Paul Hoadley wrote: > On 07/12/2010, at 6:13 AM, Chuck Hill wrote: > >> Is there a Wiki page for EOF and Postgres? It strikes me as this is >> something that should be documented. I don't think we can "fix" it, as it >> would impact people with existing data. >

Re: Timestamps and PostgreSQL

2010-12-06 Thread Ramsey Gurley
On Dec 6, 2010, at 5:10 PM, Paul Hoadley wrote: On 07/12/2010, at 6:13 AM, Chuck Hill wrote: Is there a Wiki page for EOF and Postgres? It strikes me as this is something that should be documented. I don't think we can "fix" it, as it would impact people with existing data. I can put

Re: Timestamps and PostgreSQL

2010-12-06 Thread Paul Hoadley
On 07/12/2010, at 6:13 AM, Chuck Hill wrote: > Is there a Wiki page for EOF and Postgres? It strikes me as this is > something that should be documented. I don't think we can "fix" it, as it > would impact people with existing data. I can put it here: http://wiki.objectstyle.org/confluence/

Re: Timestamps and PostgreSQL

2010-12-06 Thread Chuck Hill
Is there a Wiki page for EOF and Postgres? It strikes me as this is something that should be documented. I don't think we can "fix" it, as it would impact people with existing data. On Dec 5, 2010, at 1:38 AM, Paul Hoadley wrote: > I just couldn't let this go. Anyone not using PostgreSQL c

Re: Timestamps and PostgreSQL

2010-12-05 Thread Paul Hoadley
On 05/12/2010, at 8:08 PM, Paul Hoadley wrote: > EOF calls PreparedStatement.setTimestamp(int, Timestamp) (implemented in > AbstractJdbc2Statement), which in turn calls > PreparedStatement.setTimestamp(int, Timestamp, Calendar) with a null Calendar. Just for completeness, that's not quite true.

Re: Timestamps and PostgreSQL

2010-12-05 Thread Paul Hoadley
I just couldn't let this go. Anyone not using PostgreSQL can tune out. On 04/12/2010, at 9:47 AM, Paul Hoadley wrote: >>> Displaying those times _without_ a formatter in the app shows the first >>> timestamp as '2010-12-03 04:51:55 Etc/GMT' which is exactly as expected, >>> but the second (tha

Re: Timestamps and PostgreSQL

2010-12-03 Thread Paul Hoadley
Hi Chuck, On 04/12/2010, at 5:29 AM, Chuck Hill wrote: > On Dec 2, 2010, at 9:23 PM, Paul Hoadley wrote: > >> Hello, >> >> I am trying to debug a timestamp issue. > > Run away to New Zealand. South Island. Assume a new identity. Save > yourself while you still can! Yeah, that's how I feel

Re: Timestamps and PostgreSQL

2010-12-03 Thread Andrew Lindesay
It really doesn't help Chuck; we've got users, WebObjects and timezones here too. I did once know about GMT0 and PG, but I haven't used PG in production for a couple of years now. I think I did configure a PG server host to GMT0 once and a colleague tells me that he "configured postgres.conf

Re: Timestamps and PostgreSQL

2010-12-03 Thread Chuck Hill
On Dec 2, 2010, at 9:23 PM, Paul Hoadley wrote: > Hello, > > I am trying to debug a timestamp issue. Run away to New Zealand. South Island. Assume a new identity. Save yourself while you still can! > In development I am using PostgreSQL 8.2.5 (8.4.4 in deployment), WO 5.4.3, > Postgresq