Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4F0092E3403 for ; Wed, 2 Jan 2008 16:28:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 90166-09 for ; Wed, 2 Jan 2008 16:28:11 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 9D8DB2E340D for ; Wed, 2 Jan 2008 16:28:13 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so9497000waf.5 for ; Wed, 02 Jan 2008 12:28:11 -0800 (PST) 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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=uyo+fM3Yd5tMNI/PORYlKKg/NrLeYOJUjXczJYbmiUk=; b=tUMEPGoKyVns+zhcc9K2zZzASeF9jpHqhhC4U+Bhcy5xyC5nVxYwmHuwhqI7ZTEQMp8ktuZwT0PsTlV5XwVbsSfvBtH1nMBzl7+6jCmSIxLS9HeSJj2uM9HQwT/EuDlV1kkDxWwChx6Pw1kv4KKi7L3tunWICL67aQ9ElNl95hA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=PyZ4xrRO79Zz2SCKcJqM76GHxFDoj9dOcztOlWSLDdxAmSo1StoQXB8ycnW8QMImFSF1prGavHeEWp0WL1IAmY40jwMxuA9BFpwy0owSBCD40+/cvwT8UDjfAsA1TflAW3PVh5hda4x69YKC/cgsCF6IyubQRCvkChJlks6oZgk= Received: by 10.114.204.7 with SMTP id b7mr16206407wag.124.1199305088694; Wed, 02 Jan 2008 12:18:08 -0800 (PST) Received: by 10.114.131.4 with HTTP; Wed, 2 Jan 2008 12:18:08 -0800 (PST) Message-ID: Date: Wed, 2 Jan 2008 14:18:08 -0600 From: "Scott Marlowe" To: "Fernando Hevia" Subject: Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Cc: "SQL Postgresql List" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/11 X-Sequence-Number: 29865 Wow! I just looked this up on the web, and all I can say is, this was a really stupid idea on the part of the govt in Argentina. It takes more than a couple days to create new timezone files and deploy them normally. I've been reading up on zic and wondering if it's a reasonable thing to try and update the pg tz db to include the new argentinian DST change. Where is the tz info stored in postgres? In the catalog? I'd be willing to take a whack at making a new tz file for argentina if I knew where it was and how to change it. (scuttles off to look at the 8.2.5 source)