On Thu, Jan 03, 2002 at 03:56:23PM +0000, Thomas Lockhart wrote:
> > The basic difference is that timestamp2tm() with right output do
> > code that call localtime() and timestamp2tm() with bad output skip
> > it, because 'tzp' is not defined ("if (tzp != NULL)" in this
> > timestamp2tm()).
> Ah! Have you tried calling timestamptz_date() instead? That one allows
> handling time zones internally. Before 7.2, timestamp_date() did handle
> time zones, but now we have TIMESTAMP WITHOUT TIME ZONE and TIMESTAMP
> WITH TIME ZONE so those internal routines changed out from under you.
You are right.
I don't want send patch with 2 chars. Can you or anyone other fix it
in src/backend/utils/adt/formatting.c in function to_date (line cca
3130) and rename timestamp_date to timestamptz_date?
Thanks. The formatting.c is ready to RC1 with this fix.
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
In response to
pgsql-hackers by date
|Next:||From: Hannu Krosing||Date: 2002-01-04 11:45:43|
|Subject: Re: LWLock contention: I think I understand the problem|
|Previous:||From: Daniel Kalchev||Date: 2002-01-04 08:07:21|
|Subject: Re: Bulkloading using COPY - ignore duplicates? |