Skip site navigation (1) Skip section navigation (2)

can't create timestamp field (only timestamp with time zone)

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: can't create timestamp field (only timestamp with time zone)
Date: 2001-07-07 01:31:30
Message-ID: 200107070131.f671VUU09116@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Dave E Martin (xxiii(at)cyberdude(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
can't create timestamp field (only timestamp with time zone)

Long Description
7.1.2 on debian

It appears to be impossible to create a field with the "timestamp" data type. only the "timestamp with time zone" type.

the "time" type seems to work correctly, but not "timestamp".

Sample Code
All of these:

create table x (m timestamp, o timestamp without time zone);
create table x (m datetime, o timestamp without time zone);
create table x (m timestamp with time zone, o timestamp without time zone);

result in:

radacct=# \d x
                    Table "x"
 Attribute |           Type           | Modifier 
-----------+--------------------------+----------
 m         | timestamp with time zone | 
 o         | timestamp with time zone | 

This however:
create table x (m time, o time without time zone, w time with time zone);

seems to work:
radacct=# \d x
                 Table "x"
 Attribute |        Type         | Modifier 
-----------+---------------------+----------
 m         | time                | 
 o         | time                | 
 w         | time with time zone | 


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Justin CliftDate: 2001-07-07 06:08:47
Subject: Re: Postmaster 7.1.2 hanging
Previous:From: pgsql-bugsDate: 2001-07-07 00:54:48
Subject: Perl DBI Module fails to install correctly from RPM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group