timestamps cannot be created without time zones

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2001-08-23T00:17:36Z
Lists: pgsql-bugs
Rainer Mager (rmager@vgkk.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
timestamps cannot be created without time zones

Long Description
Creating a TABLE with a TIMESTAMP type seems to ignore the WITH TIME ZONE option. That is, with or without the option the TIMESTAMP still has a time zone.

Sample Code
vgkk=> create table a ( t1 timestamp, t2 timestamp with time zone, t3 timestamp without time zone );
CREATE
vgkk=> \d a
                    Table "a"
 Attribute |           Type           | Modifier 
-----------+--------------------------+----------
 t1        | timestamp with time zone | 
 t2        | timestamp with time zone | 
 t3        | timestamp with time zone | 


No file was uploaded with this report