[ADMIN] Bad timestamp 7.1->7.2

I created a database on postgres 7.1 one of the fields was defined with a default of : 'select now()::"timestamp" When I try to create this table under 7.2 it fails. Is there a new way to do timestamping of records? ---(end of broadcast)--- TIP 6

Re: [ADMIN] Bad timestamp 7.1->7.2

Doug Needham <[EMAIL PROTECTED]> writes: > I created a database on postgres 7.1 > one of the fields was defined with a default of : > 'select now()::"timestamp" > When I try to create this table under 7.2 it fails. Hmm, looks fine to me: regression=# create table foobar (f1 timestamp default