From: | "Alex" <alex(at)quad(dot)com(dot)ar> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | timestamp being timestamp with time zone |
Date: | 2001-05-15 18:52:26 |
Message-ID: | 000901c0dd70$2f9a4950$0201a8c0@ALEX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Alex Verstraeten
Your email address : alex(at)quad(dot)com(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2001-05-16 00:47:03 | GRANT permissions on views have no effect; \dv reports nothing |
Previous Message | Chris Storah | 2001-05-15 16:36:52 | Re: socket slowdown using libpg and 7.1.1 ? |