!
JB
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, February 25, 2011 11:15 AM
To: j...@blackskytech.com; pgsql-bugs@postgresql.org; 'Tom Lane'
Subject: RE: [BUGS] LOCALTIMESTAMP has wrong time zone
"Jonathan Brinkman" wrote:
>
"Jonathan Brinkman" wrote:
> ## I COULDN'T MAKE IT BREAK USING PSQL.
That's pretty solid evidence that the problem isn't in the
PostgreSQL server.
> This didn't always happen, it just started happening on various of
> my tables a maybe couple weeks or so ago. I think it is related to
> an up
0) WITHOUT TIME ZONE DEFAULT
'now'::text::timestamp without time zone,
CONSTRAINT "pk_general_comments_commentid" PRIMARY KEY("commentid"),
) WITH OIDS;
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, February 24, 201
35 PM
To: Kevin Grittner
Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
>> My default timestamps in my database all are +5 hours in the future
> Can you c
"Jonathan Brinkman" writes:
> postgres@Cloud-DB1:~$ psql beta_cms_main -c "show timezone;"
> TimeZone
> --
> EST
> (1 row)
Hmmm ... you do realize that that setting will result in EST (GMT-5)
all year round? It's more likely that you want America/New_York.
That's not your immediate pro
"Jonathan Brinkman" wrote:
> "createddatetime" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),
What happens if you use TIMESTAMP WITH TIME ZONE?
Can you provide a more complete, self-contained example, like this?:
test=# drop table if exists show_ts_issue;
DROP TABLE
test=# CREATE TABLE "
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
>> My default timestamps in my database all are +5 hours in the future
> Can you copy paste actual statements and results?
In particular, let's see the result of these commands in psql:
show timezone;
select now();
"Jonathan Brinkman" wrote:
> My default timestamps in my database all are +5 hours in the future
Can you copy paste actual statements and results?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Greetings
I'm in Florida (Eastern Time Zone / New York), using Ubuntu 10.04LTS /
Postgresql 8.4.7.
My default timestamps in my database all are +5 hours in the future
(probably GMT), unless I code the 'EST' time zone into the field's default
(timezone('EST'::text, now())).If I use now() it is +5 h
