timestamps cannot be created without time zones

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: timestamps cannot be created without time zones
Date: 2001-08-23 00:17:36
Message-ID: 200108230017.f7N0HaF46664@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Rainer Mager (rmager(at)vgkk(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-08-23 10:17:49 Bug #422: testing the subject and header changes
Previous Message Tom Lane 2001-08-22 23:19:42 Re: Re: low performance