Rainer Mager ([EMAIL PROTECTED]) 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
