BUG #9088: default are not working - Mailing list pgsql-bugs

From plademan@comcast.net
Subject BUG #9088: default are not working
Date
Msg-id 20140203222323.13575.44279@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9088: default are not working
Re: BUG #9088: default are not working
List pgsql-bugs
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;

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #9068: invalid YY_START on Unicode identifier escape syntax
Next
From: Thomas Kellerer
Date:
Subject: Re: BUG #9088: default are not working