X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 59E9ED1F461
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Aug 2003 04:13:26 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 62949-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Aug 2003 01:11:48 -0300 (ADT)
Received: from davinci.ethosmedia.com (unknown [209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id 2FFAAD1C7F3
	for <pgsql-sql@postgresql.org>; Thu, 14 Aug 2003 01:13:11 -0300 (ADT)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3511412; Wed, 13 Aug 2003 21:13:19 -0700
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Jesse Scott <scotje@wwc.edu>
Subject: Re: Timezone troubles
Date: Wed, 13 Aug 2003 21:12:44 -0700
User-Agent: KMail/1.4.3
References: <3F3B001B.8060506@wwc.edu>
In-Reply-To: <3F3B001B.8060506@wwc.edu>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200308132112.44171.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/168
X-Sequence-Number: 14784

Jesse,

> Here is the data definition and the query (version is 7.2.3 btw):
<snip>
>   lastlogin timestamp DEFAULT 'now',
>   firstlogin timestamp,

In 7.2.x, unless you declare a timestamp as "TIMESTAMP WITHOUT TIME ZONE", it 
is automatically created as *with* time zone.   I think this may be your 
problem.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco