Re: [GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-06-01 Thread Adrian Klaver
7;Adrian Klaver *EXTERN*'; Rishi Gokhale; pgsql-general@postgresql.org Subject: RE: [GENERAL] date type changing to timestamp without time zone in postgres 9.4 Adrian Klaver wrote: On 05/30/2015 10:05 PM, Rishi Gokhale wrote: When I create a table with a column whose type is date the type gets

Re: [GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-06-01 Thread Albe Laurenz
Rishi Gokhale wrote: > Thanks very much for your quick responses. I am indeed using EDB's postgres > plus. > > It looks like it has a function thats forcing the date type to change to a > timestamp. I actually > deleted that function, but it still didn't help. You shouldn't delete any functions

Re: [GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-06-01 Thread Rishi Gokhale
nks, Rishi From: Albe Laurenz Sent: Monday, June 1, 2015 3:32 AM To: 'Adrian Klaver *EXTERN*'; Rishi Gokhale; pgsql-general@postgresql.org Subject: RE: [GENERAL] date type changing to timestamp without time zone in postgres 9.4 Adrian Klaver wrote: > On 05/30/2015 10:05

Re: [GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-06-01 Thread Albe Laurenz
Adrian Klaver wrote: > On 05/30/2015 10:05 PM, Rishi Gokhale wrote: >> 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(# namevarchar(40) NOT NULL, >> ops(# start dat

Re: [GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-05-31 Thread Adrian Klaver
On 05/30/2015 10:05 PM, Rishi Gokhale wrote: 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(# namevarchar(40) NOT NULL, ops(# start date NOT NULL ops(# ); CREATE TABLE

[GENERAL] date type changing to timestamp without time zone in postgres 9.4

2015-05-30 Thread Rishi Gokhale
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(# namevarchar(40) NOT NULL, ops(# start date NOT NULL ops(# ); CREATE TABLE ops=# \d test; Table "public.