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

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема BUG?: timestamp without TZ created as timestamp *with* TZ
Дата
Msg-id 3D6E240C.70505@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: BUG?: timestamp without TZ created as timestamp *with* TZ  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Следующее
От: "Jules Alberts"
Дата:
Сообщение: Re: Securing sensitive information