X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F48FD1B512
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 11:14:27 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 87105-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 08:13:57 -0300 (ADT)
Received: from mailer (unknown [202.134.191.30])
	by svr1.postgresql.org (Postfix) with ESMTP id 97B14D1B518
	for <pgsql-sql@postgresql.org>; Fri, 26 Sep 2003 08:13:51 -0300 (ADT)
Received: from guardian1 [202.134.173.175] by mailer
	(SMTPD32-8.02) id AFAA1D50070; Fri, 26 Sep 2003 16:44:50 +0530
From: "The Guardian" <theguardian@vsnl.net>
To: <pgsql-sql@postgresql.org>
Subject: Problems to be solved as soon as possible
Date: Fri, 26 Sep 2003 16:43:44 +0530
Message-ID: <EBEDKBEGBLEDODHNFHBLMEFOCAAA.theguardian@vsnl.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=4.7 tagged_above=0.0 required=5.0 tests=BAYES_30,
	MSGID_GOOD_EXCHANGE, RCVD_IN_DSBL, RCVD_IN_NJABL, SMTPD_IN_RCVD
X-Spam-Level: ****
X-Archive-Number: 200309/391
X-Sequence-Number: 15369


Dear Support Team,
	We are hosting a website which was originally designed in some version of
Debian Linux and having PostgreSQL as back end. The developers have made a
script which creates several tables in the database. Some of the tables have
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."
	So can you please guide me what changes i have to make in the script of
creating tables at my end as a customer so that my application runs
smoothly.

Regards,
The Guardian.
Ph: 31074723 / 32511869.
Website: www.guardianindia.com
Email:   theguardian@vsnl.net