Обсуждение: Problems to be solved as soon as possible.

Поиск
Список
Период
Сортировка

Problems to be solved as soon as possible.

От
"The Guardian"
Дата:
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:   theguardian@vsnl.net




Re: Problems to be solved as soon as possible.

От
Andreas Pflug
Дата:
Hiren,

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:   theguardian@vsnl.net
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>  
>