timestamp being timestamp with time zone

Поиск
Список
Период
Сортировка
От Alex
Тема timestamp being timestamp with time zone
Дата
Msg-id 000901c0dd70$2f9a4950$0201a8c0@ALEX
обсуждение исходный текст
Список pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name  : Alex Verstraeten
Your email address : alex@quad.com.ar


System Configuration
---------------------
  Architecture (example: Intel Pentium)   : Intel Pentium III

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.2.19 ELF

  PostgreSQL version (example: PostgreSQL-7.1.1):   PostgreSQL-7.1.1

  Compiler used (example:  gcc 2.95.2)  : gcc version 2.95.2 20000220
(Debian GNU/Linux)


Please enter a FULL description of your problem:
------------------------------------------------

When creating a table with a timestamp date type, timestamp becomes
timestamp with time zone.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

in psql:
CREATE TABLE "foo" ( bar timestamp );
\d  foo

                   Table "foo"
 Attribute |           Type           | Modifier
-----------+--------------------------+----------
 bar       | timestamp with time zone |


another sample:
CREATE TABLE "bar" ( foo timestamp without time zone );
\d bar

                   Table "bar"
 Attribute |           Type           | Modifier
-----------+--------------------------+----------
 foo       | timestamp with time zone |


by reading the current docs
(http://postgresql.readysetnet.com/devel-corner/docs/postgres/datatype-datet
ime.html) I can tell timestamp and timestamp with time zone are two
different date/time types.



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

I'm afraid not.

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

Предыдущее
От: "Todd R. Eigenschink"
Дата:
Сообщение: Re: REQ: build src/backend/postgres w/o -lncurses or -lreadline
Следующее
От: John Aughey
Дата:
Сообщение: Unusual slowdown using subselects