you're on the wrong list; this is for pgAdmin issues, not about the PostgreSQL backend.
Please do your posting on pgsql-sql to get answers for your problem.
Regards, Andreas
PS you need to state the version of the PostgreSQL server, not the Linux server to get detailed support.
The Guardian wrote:
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, Hiren. The Guardian. Ph: 31074723 / 32511869. Website: www.guardianindia.com Email: [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match