Steve Howe <howe@carcass.dhs.org> writes:
> Just wondering if the datetime type was dropped on purpose from
> PostgreSQL 7.3 ?

Yes.  Ad-hoc name translations in the parser create bogosities with
respect to schemas --- I forget the details, but it was either drop
"datetime" or make it a reserved keyword.  Since datetime has been
deprecated for a couple releases now, the choice seemed clear.

			regards, tom lane

Wed, 06 Nov 2002 23:17:00 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Datetime type dropped from v7.3 ? 
Hello all,

Just wondering if the datetime type was dropped on purpose from
PostgreSQL 7.3 ?
This is not an issue of course, I'll be using timestamp, but it's
weird having that dropped.

-------------------------------
-- On PostgreSQL 7.2:
-------------------------------
howe=# select version();
                                version                                
-----------------------------------------------------------------------
 PostgreSQL 7.2.1 on i386-portbld-freebsd4.6.2, compiled by GCC 2.95.3
(1 row)

howe=# create table a(b datetime);
CREATE
howe=# \d a
                    Table "a"
 Column |            Type             | Modifiers 
--------+-----------------------------+-----------
 b      | timestamp without time zone |

 
-------------------------------
-- On PostgreSQL 7.3:
-------------------------------
howe=# select version ();
                               version                               
---------------------------------------------------------------------
 PostgreSQL 7.3b3 on i386-unknown-freebsd4.4, compiled by GCC 2.95.3
(1 row)

howe=# create table a(b datetime);
ERROR:  Type "datetime" does not exist

------------- 
Best regards,
 Steve Howe                           mailto:howe@carcass.dhs.org


Thu, 7 Nov 2002 02:09:51 -0300
Steve Howe <howe@carcass.dhs.org>
Datetime type dropped from v7.3 ?
Hello Tom,

Thursday, November 7, 2002, 1:17:00 AM, you wrote:

TL> Steve Howe <howe@carcass.dhs.org> writes:
>> Just wondering if the datetime type was dropped on purpose from
>> PostgreSQL 7.3 ?

TL> Yes.  Ad-hoc name translations in the parser create bogosities with
TL> respect to schemas --- I forget the details, but it was either drop
TL> "datetime" or make it a reserved keyword.  Since datetime has been
TL> deprecated for a couple releases now, the choice seemed clear.
Oh. ok. I'm glad it was intended.
Thanks :)

------------- 
Best regards,
 Steve Howe                           mailto:howe@carcass.dhs.org


Thu, 7 Nov 2002 02:20:19 -0300
Steve Howe <howe@carcass.dhs.org>
Re: Datetime type dropped from v7.3 ?