Re: [SQL] 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:

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

Peter Eisentraut [EMAIL PROTECTED] writes: David B wrote: 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 () Whatever it was, that was not the problem. With 7.4.1:

[SQL] In 7.4 ensure you have DEFAULT now () with no spaces

Just a heads up folks... In converting from 7.3 to 7.4 one got-ya we had was... 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