Re: In 7.4 ensure you have DEFAULT now () with no spaces

David B wrote:
> We had been testing 7.4 for a few days and just noticed that some
> tables had created_timestamp rows with a date/time of the date the DB
> was created...not the date/time the insert was done.
>
> Looking at those tables the create DDL's for those few tables
> contained now ()
> as in:
>
> created_timestamp  timestamp DEFAULT now ()   -- note the space
> between now and ()
>
> Most had correctly been defined without the space - as in now()

Whatever it was, that was not the problem.  With 7.4.1:

peter=# create table test1 (foo text, create_timestamp timestamp default now());
CREATE TABLE
peter=# create table test2 (foo text, create_timestamp timestamp default now ());
CREATE TABLE
peter=# create table test3 (foo text, create_timestamp timestamp default now
peter(# /* blah */
peter(# (
peter(# /* blah */
peter(# )
peter(# )
peter-# ;
CREATE TABLE
peter=# \d test1                     Table "public.test1"     Column      |            Type             |   Modifiers
------------------+-----------------------------+---------------foo              | text
|create_timestamp| timestamp without time zone | default now()
 

peter=# \d test2                     Table "public.test2"     Column      |            Type             |   Modifiers
------------------+-----------------------------+---------------foo              | text
|create_timestamp| timestamp without time zone | default now()
 

peter=# \d test3                     Table "public.test3"     Column      |            Type             |   Modifiers
------------------+-----------------------------+---------------foo              | text
|create_timestamp| timestamp without time zone | default now()
 

They're all identical.