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 62F36D1C7F7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Aug 2003 04:38:44 +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 70697-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Aug 2003 01:37:05 -0300 (ADT)
Received: from titan.wwc.edu (unknown [66.62.165.251])
	by svr1.postgresql.org (Postfix) with ESMTP id 973DBD1F472
	for <pgsql-sql@postgresql.org>; Thu, 14 Aug 2003 01:37:43 -0300 (ADT)
Received: from wwc.edu (scotma-w2.wwc.edu [172.17.66.3])
	by titan.wwc.edu (Postfix) with ESMTP id 610821040C
	for <pgsql-sql@postgresql.org>; Wed, 13 Aug 2003 21:37:09 -0700 (PDT)
Message-ID: <3F3B124D.6080606@wwc.edu>
Date: Wed, 13 Aug 2003 21:38:37 -0700
From: Jesse Scott <scotje@wwc.edu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.5a) Gecko/20030625 Thunderbird/0.1a
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Postgresql SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Timezone troubles
References: <3F3B001B.8060506@wwc.edu> <200308132112.44171.josh@agliodbs.com>
In-Reply-To: <200308132112.44171.josh@agliodbs.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/169
X-Sequence-Number: 14785

Ok, I was actually dyslexic when I read the version number, I have 7.3.2 
not 7.2.3, I'll investigate the timezone status though.

Thanks,

-Jesse

Josh Berkus wrote:

>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.
>
>  
>