date type changing to timestamp without time zone in postgres 9.4

From: Rishi Gokhale <rgokhale(at)bjondinc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: date type changing to timestamp without time zone in postgres 9.4
Date: 2015-05-31 05:05:17
Message-ID: CY1PR0501MB1817CD34825F2DEFE8852461ADB70@CY1PR0501MB1817.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I create a table with a column whose type is date the type gets forced to timestamp without timezone after it gets created

ops=# CREATE TABLE test (

ops(# name varchar(40) NOT NULL,

ops(# start date NOT NULL

ops(# );

CREATE TABLE

ops=# \d test;

Table "public.test"

Column | Type | Modifiers

--------+-----------------------------+-----------

name | character varying(40) | not null

start | timestamp without time zone | not null

ops=#

The table creation is just a test, my original issue is while restoring a backup (pg_dump/pg_restore) from another server also 9.4, where the date types on numerous columns get forced to change to timestamp without timezone.

Any help would be appreciated.

Thanks,

Rishi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-05-31 05:53:37 Re: Efficient sorting the results of a join, without denormalization
Previous Message Glen M. Witherington 2015-05-31 04:43:25 Re: Efficient sorting the results of a join, without denormalization