Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id A1FFB2E3232
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  2 Jan 2008 16:27:15 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 47526-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  2 Jan 2008 16:27:06 -0400 (AST)
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.177])
	by postgresql.org (Postfix) with ESMTP id 18C8C2E2E8C
	for <pgsql-sql@postgresql.org>; Wed,  2 Jan 2008 16:27:08 -0400 (AST)
Received: by wa-out-1112.google.com with SMTP id m38so9496535waf.5
	for <pgsql-sql@postgresql.org>; Wed, 02 Jan 2008 12:27:07 -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:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	bh=XhJuj24ugj/Cvr8nYCHVktJtO2dBLL55RDpFJSKi2+4=;
	b=Cbd1wPVP/3OBodWKEnENbabEFwo7tLiGXO+8/Hoyn2UWjukXYUDFjdYdcff1pm3l7UlqXPEaYD4A6P1+NfGRuWe9NOVh/wDPZDukX2UtAp7uF3Lt5a3zgmz2no5f0WDAWy/VdyrcKsMBe8vzXXlADG4B98XbEbAFty1XEaXmq6M=
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=IHwpydKcyy6ph/sE20QUZYIm+XUPZ4VkHYp3jcOyvQGf4zl1c7KXLY2mzVVtVwjVaO2XA6d1utwYBV4qJ8OfaINiFguGKPUbzhkdfyMAdJgIOFURSB185utwCdISvCFVFbKtC7WOsjGS+BmnBckDCSVzr3HAn/m8ovOCwjmnPnI=
Received: by 10.114.80.4 with SMTP id d4mr15450408wab.44.1199305627187;
	Wed, 02 Jan 2008 12:27:07 -0800 (PST)
Received: by 10.114.131.4 with HTTP; Wed, 2 Jan 2008 12:27:07 -0800 (PST)
Message-ID: <dcc563d10801021227h15e36570qbbb55e3b7a1d72ef@mail.gmail.com>
Date: Wed, 2 Jan 2008 14:27:07 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Fernando Hevia" <fhevia@ip-tel.com.ar>
Subject: Re: PG is in different timezone than the OS
Cc: "SQL Postgresql List" <pgsql-sql@postgresql.org>
In-Reply-To: <dcc563d10801021206m24c23294m49d9855ddd670a73@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <00ff01c84d6f$65e64ec0$8f01010a@iptel.com.ar>
	<dcc563d10801021206m24c23294m49d9855ddd670a73@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/10
X-Sequence-Number: 29864

Carrying on a convo with myself here.

Looking in the timezone directory, and looking at the tz database
located at ftp://elsie.nci.nih.gov/pub/ it appears the southamerica
timezone data was updated 2007-12-13 at 9am or so.  Looking through
the file it looks like the change was made:

# From Steffen Thorsen (2007-12-21):
# A user (Leonardo Chaim) reported that Argentina will adopt DST....
# all of the country (all Zone-entries) are affected.  News reports like
# http://www.lanacion.com.ar/opinion/nota.asp?nota_id=973037 indicate
# that Argentina will use DST next year as well, from October to
# March, although exact rules are not given.
#
# From Jesper Norgaard Welen (2007-12-26)
# The last hurdle of Argentina DST is over, the proposal was approved in
# the lower chamber too (Deputados) with a vote 192 for and 2 against.
# By the way thanks to Mariano Absatz and Daniel Mario Vega for the link to
# the original scanned proposal, where the dates and the zero hours are
# clear and unambiguous...This is the article about final approval:
# <a href="http://www.lanacion.com.ar/politica/nota.asp?nota_id=973996">
# http://www.lanacion.com.ar/politica/nota.asp?nota_id=973996
# </a>
#
# From Paul Eggert (2007-12-22):
# For dates after mid-2008, the following rules are my guesses and
# are quite possibly wrong, but are more likely than no DST at all.
Rule    Arg     2007    only    -       Dec     30      0:00    1:00    S
Rule    Arg     2008    max     -       Mar     Sun>=15 0:00    0       -
Rule    Arg     2008    max     -       Oct     Sun>=1  0:00    1:00    S

So, it appears that the timezone folks know...

Note that I added pgsql-general, as this isn't really a -sql question.
 Next person to reply please remove the -sql group.