| 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: | Whole Thread | Raw Message | 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
| 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 |