Re: timestamp column default changed? - Mailing list pgsql-hackers

From Laurette Cisneros
Subject Re: timestamp column default changed?
Date
Msg-id Pine.LNX.4.44.0209111502530.7585-100000@visor.corp.nextbus.com
Whole thread Raw
In response to Re: timestamp column default changed?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: timestamp column default changed?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: timestamp column default changed?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
I'm sure you all have discussed this ad-nauseum but this sure does create a
pain in the butt when converting.

Ok, I had my say.

Thanks for all your hard work,

L.
On Wed, 11 Sep 2002, Bruce Momjian wrote:

> Laurette Cisneros wrote:
> > 
> > If you define a column as:
> > col    timestamp
> > In 7.2.x didn't it default to timestamp with timezone?
> > 
> > And now in 7.3(b1) it defaults to timestamp without timezone?
> 
> /HISTORY says right at the top:
> 
>      * TIMESTAMP and TIME data types now default to WITHOUT TIMEZONE
> 
> 

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
A wiki we will go...



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: timestamp column default changed?
Next
From: Stephan Szabo
Date:
Subject: Re: problem with new autocommit config parameter and jdbc