Re: Trouble with pg_dumpall import with 7.2 - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Trouble with pg_dumpall import with 7.2
Date
Msg-id 3C7510B7.1C2AEA35@fourpalms.org
Whole thread Raw
In response to Re: Trouble with pg_dumpall import with 7.2  (Masaru Sugawara <rk73@echna.ne.jp>)
List pgsql-hackers
...
> BTW, 7.2 assumes plain "timestamp" to denote "timestamp with time zone";
> this is for backwards compatibility with the behavior of previous
> releases' timestamp datatype.  However, the SQL spec says that
> "timestamp" should mean ""timestamp without time zone", so we are
> probably going to change over eventually.
> (Hey Thomas, did I get all that right?)

Yes, including the change in default in an upcoming release. Well,
actually I have to admit I lost concentration somewhere in the middle of
the "power examples" so didn't check those carefully ;) :))
               - Thomas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error with a SQL query 'between .. and .. and'
Next
From: Colin Faber
Date:
Subject: Re: PostgreSQL 8.0 ??