From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: The Guardian <theguardian@vsnl.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problems to be solved as soon as possible
Date: Mon, 29 Sep 2003 15:12:14 -0400
Message-ID: <27579.1064862734@sss.pgh.pa.us> (raw)
In-Reply-To: <3F7876A8.4050409@klaster.net>
References: <EBEDKBEGBLEDODHNFHBLMEFOCAAA.theguardian@vsnl.net>
<3F7876A8.4050409@klaster.net>
Tomasz Myrta <jasiek@klaster.net> writes:
>> datatypes like DateTime. When i run those scripts in PostgreSQL of Red hat
>> Linux 7.2, they run perfectly. But when i run the same scrips in PostgreSQL
>> of Redhat Linux 9.0, it displays an error message of "data type DATETIME not
>> found."
> It looks like Postgresql problem, not a Redhat problem. Probably
> datetime is some not longer supported datatype.
Yes, "datetime" is an ancient name for what we now call by the
SQL-standard name "timestamp with time zone".
If changing to the standard name makes for too many changes in your
application code, you could use a domain as a kind of type alias:
create domain datetime as timestamp with time zone;
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, jasiek@klaster.net, theguardian@vsnl.net
Subject: Re: Problems to be solved as soon as possible
In-Reply-To: <27579.1064862734@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox