The following bug has been logged on the website:
Bug reference: 9088
Logged by: Patrick Lademan
Email address: plademan@comcast.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;