BUG #9088: default are not working

From: plademan(at)comcast(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9088: default are not working
Date: 2014-02-03 22:23:23
Message-ID: 20140203222323.13575.44279@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9088
Logged by: Patrick Lademan
Email address: plademan(at)comcast(dot)net
PostgreSQL version: 9.3.1
Operating system: OS X 10.9.1 (13B42)
Description:

It appears that default values are no longer working in 9.3.1.

This is the version that I am running:
"PostgreSQL 9.3.1 on x86_64-apple-darwin, compiled by
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build
5658) (LLVM build 2336.9.00), 64-bit"

-- Test Case
drop table default_test;

create table default_test
(
userId varchar(20) default 'test',
date1 timestamp default now(),
date2 timestamp default current_timestamp,
date3 timestamp default localtimestamp
);

insert into default_test
( userId, date1, date2, date3 )
values
( null, null, null, null );

select * from default_test;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Kellerer 2014-02-03 22:30:32 Re: BUG #9088: default are not working
Previous Message craigmluacs 2014-02-03 21:29:42 BUG #9087: Foreign data wrapper connection management issues