timestamps cannot be created without time zones

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема timestamps cannot be created without time zones
Дата
Msg-id 200108230017.f7N0HaF46664@hub.org
обсуждение исходный текст
Ответы Re: timestamps cannot be created without time zones  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
Rainer Mager (rmager@vgkk.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
theTIMESTAMP 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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: low performance
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #422: testing the subject and header changes