On Tue, Jun 30, 2009 at 8:45 AM, Tom Lane wrote:
> Scott Marlowe writes:
>> If I remember correctly, the sql standard says that timestamp, alone,
>> means timestamp without timezone. But prior to 8.1 pgsql implemented
>> timestamp as timestamp with timezone.
>
> No, you're thinking of a change th
Scott Marlowe writes:
> If I remember correctly, the sql standard says that timestamp, alone,
> means timestamp without timezone. But prior to 8.1 pgsql implemented
> timestamp as timestamp with timezone.
No, you're thinking of a change that happened in 7.3.
regards, tom
On Tue, Jun 30, 2009 at 1:13 AM, Rajdeep Das wrote:
> Dear Sir/Madam,
> This is important and I need your help here.
> I have taken a dump of my database from the old version of pg viz.8.1, using
> pg_dump command. In the db I have a table with a column of datatype
> 'timestamp'. Now, when I try to
Rajdeep Das writes:
> I have taken a dump of my database from the old version of pg viz.8.1, using
> pg_dump command. In the db I have a table with a column of datatype
> 'timestamp'. Now, when I try to restore it on the new pg version 8.3, the
> datatype of the column is getting altered to 'times
Dear Sir/Madam,
This is important and I need your help here.
I have taken a dump of my database from the old version of pg viz.8.1, using
pg_dump command. In the db I have a table with a column of datatype
'timestamp'. Now, when I try to restore it on the new pg version 8.3, the
datatype of the c
