BUG?: timestamp without TZ created as timestamp *with* TZ

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: BUG?: timestamp without TZ created as timestamp *with* TZ
Date: 2002-08-29 13:39:24
Message-ID: 3D6E240C.70505@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems that even though I declare a columns to be of type timestamp
without time zone it gets created as a data type *with* a time zone?

Did I miss something?

Here my SQL:

create table MEMBERS (

id serial primary key,
login text unique not null,
first_name char(64) not null,
last_name char(64) not null,
first_name_kana char(64) not null,
last_name_kana char(64) not null,
primary_email text not null,
pw_hash text not null,
membership_type integer references MEMBERSHIP_TYPES(id),
sex char(1) ,
dob date ,
payment_type integer references PAYMENT_TYPES(id),
last_login timestamp without time zone [0],
disabled boolean default true
);

I then do a "\d members" and get:

Column | Type |
Modifiers
-----------------+----------------------------+----------------------------------------------------
id | integer | not null default
nextval('"members_id_seq"'::text)
login | text | not null
first_name | character(64) | not null
last_name | character(64) | not null
first_name_kana | character(64) | not null
last_name_kana | character(64) | not null
primary_email | text | not null
pw_hash | text | not null
membership_type | integer |
sex | character(1) |
dob | date |
payment_type | integer |
last_login | timestamp with time zone[] |
disabled | boolean | default 't'::bool
Primary key: members_pkey
Unique keys: members_login_key
Triggers: RI_ConstraintTrigger_2169213,
RI_ConstraintTrigger_2169219

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jules Alberts 2002-08-29 13:47:14 Re: Securing sensitive information
Previous Message Tom Lane 2002-08-29 13:29:38 Re: Free space mapping (was Re: Multi-Versions and Vacuum)