Making the setting in the postgresql.conf file worked after i HUP'd the
postmaster, and logged back into my psql sessions.
timezone = 'EST5EDT'
Thanks a million.
- Ericson
"set local" was probably not what you wanted to use here. Per the man page:
Note that SET LOCAL will appear to have no effect if it is executed outside
a BEGIN block, since the transaction will end immediately.
regards, tom lane
begin:vcard
fn:Ericson Smith
n:Smith;Ericson
org:Did-it.com;Programming
adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA
email;internet:[EMAIL PROTECTED]
title:Web Developer
tel;work:516-255-0500
tel;cell:646-483-3420
note:Nothing special!
x-mozilla-html:FALSE
url:http://www.did-it.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
