pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with SGT (Singapore) timezone
3+ messages / 3 participants
[nested] [flat]
* Problem with SGT (Singapore) timezone
@ 2008-04-24 08:45 Abhishek Mishra <abhishek.mishra@globallogic.com>
2008-04-24 15:30 ` Re: Problem with SGT (Singapore) timezone Tom Lane <tgl@sss.pgh.pa.us>
2008-04-24 15:39 ` Re: Problem with SGT (Singapore) timezone Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Abhishek Mishra @ 2008-04-24 08:45 UTC (permalink / raw)
To: pgsql-admin
Hi Folks,
I am using postgresql version 8.1.2. On using the SGT time zone on my
machine, I get following error:
ERROR:
invalid input syntax for type timestamp: "Tue Jan 15 04:09:43.729011
2008 SGT"
Could anyone please tell me any known issue in using SGT timezone. It
works well if I use GMT timezone.
Please tell me if anything could be done to support SGT.
Kind Regards,
-Abhishek Mishra
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem with SGT (Singapore) timezone
2008-04-24 08:45 Problem with SGT (Singapore) timezone Abhishek Mishra <abhishek.mishra@globallogic.com>
@ 2008-04-24 15:30 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2008-04-24 15:30 UTC (permalink / raw)
To: Abhishek Mishra <abhishek.mishra@globallogic.com>; +Cc: pgsql-admin
Abhishek Mishra <abhishek.mishra@globallogic.com> writes:
> I am using postgresql version 8.1.2. On using the SGT time zone on my
> machine, I get following error:
> ERROR:
> invalid input syntax for type timestamp: "Tue Jan 15 04:09:43.729011
> 2008 SGT"
8.1 has a hard-wired list of timezone abbreviations, and "SGT" isn't in it.
In 8.2 and later the list of abbreviations is configurable, see
timezone_abbreviations.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem with SGT (Singapore) timezone
2008-04-24 08:45 Problem with SGT (Singapore) timezone Abhishek Mishra <abhishek.mishra@globallogic.com>
@ 2008-04-24 15:39 ` Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2008-04-24 15:39 UTC (permalink / raw)
To: Abhishek Mishra <abhishek.mishra@globallogic.com>; +Cc: pgsql-admin
On Thu, Apr 24, 2008 at 2:45 AM, Abhishek Mishra
<abhishek.mishra@globallogic.com> wrote:
> Hi Folks,
>
> I am using postgresql version 8.1.2. On using the SGT time zone on my
> machine, I get following error:
On top of what Tom said, you need to update to the latest 8.1.x
PostgreSQL has its own timezone db built in, and updating to the
latest minor version is how to keep it up to date, normally.
Also, there are some nasty bugs that far back in the 8.1 line if I
remember correctly.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-04-24 15:39 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-24 08:45 Problem with SGT (Singapore) timezone Abhishek Mishra <abhishek.mishra@globallogic.com>
2008-04-24 15:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-24 15:39 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox