Re: [ADMIN] Forcing postgres to reload current time zone.

2004-07-09 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > I'm writing an application that issues "SELECT current_timestamp" from > postgres on a regular basis to get the time. However, the user may > change the system's time zone and postgres does not seem to reflect this > change unless I restart the database daemon. I cann

[ADMIN] Forcing postgres to reload current time zone.

2004-07-08 Thread trena-no-spam
Hello, I'm writing an application that issues "SELECT current_timestamp" from postgres on a regular basis to get the time. However, the user may change the system's time zone and postgres does not seem to reflect this change unless I restart the database daemon. I cannot have all of my program th