Re: Problem with timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mageshwaran <j_mageshwaran(at)sifycorp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem with timestamp
Date: 2007-05-30 02:59:35
Message-ID: 25936.1180493975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Mageshwaran <j_mageshwaran(at)sifycorp(dot)com> writes:
> We have our application which uses postgres 7.1.3 version in
> that we use a time functions like now(),timestamp..... etc mostly
> timestamp without timezone.We don't need the timezone in that variable
> so we ignore it using timestamp without timezone. The same is not
> working with higher versions.We are facing problems in migration. We are
> able to store the dates in the database but while retrieving the driver
> is not able to retrieve.

What "driver" is that, and what goes wrong exactly?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Roman Chervotkin 2007-05-30 08:00:07 pg_dump: Error message from server: ERROR: compressed data is corrupt
Previous Message Mageshwaran 2007-05-30 02:45:11 Problem with timestamp

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-30 03:10:54 Re: prepare()
Previous Message Stuart Cooper 2007-05-30 02:50:46 Re: TimeZone List