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.