Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 7724B2E0093 for ; Thu, 24 Apr 2008 12:39:43 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68855-05 for ; Thu, 24 Apr 2008 12:39:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by developer.postgresql.org (Postfix) with ESMTP id 3CC472E0087 for ; Thu, 24 Apr 2008 12:39:31 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so181366ywb.73 for ; Thu, 24 Apr 2008 08:39:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=b0g8cyy7yvuxXEduHfdDgzjMXx7noadhb1++yql7Q2c=; b=JiT7i9YCk+tNknmmyOkQ5YlsgKj39t6H0JPpA+PMhXlc26HapCINISJLqnjAn+kGwyMpSUDyo9L8awFAveG2J/tDXUM07afmbGAF1JOBF0kKzvqQI7kg8etE8NZLjRgq4DqAxiYFKUV6TCQp3V///uTu3bxbWPAz9UpRRVs45ko= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BGg0yI7bV4AC5N6MD/nnDQGthDH0TfvUCybS7I8n3/ZRnU9G6Yf8p9unDNGfJbsv1DichpUuMCVMdiwAEprDHqW4Cql6xmNpAf+TGqduydEMPsqlJ+IVSG0OjTgPz6yCU5FN/iMU1NoXQTZzlhbbvN4f5JyVjIF+aFdXfGjvZjQ= Received: by 10.115.61.1 with SMTP id o1mr1950156wak.94.1209051566484; Thu, 24 Apr 2008 08:39:26 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Thu, 24 Apr 2008 08:39:26 -0700 (PDT) Message-ID: Date: Thu, 24 Apr 2008 09:39:26 -0600 From: "Scott Marlowe" To: "Abhishek Mishra" Subject: Re: Problem with SGT (Singapore) timezone Cc: pgsql-admin@postgresql.org In-Reply-To: <1209026751.6110.193.camel@bob> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1209026751.6110.193.camel@bob> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/246 X-Sequence-Number: 29010 On Thu, Apr 24, 2008 at 2:45 AM, Abhishek Mishra 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.