Running Postgres 7.4 on Panther, there seems to be a problem with setting a timestamp column to have a default of 'now':
createdb test
create table bar (date timestamp DEFAULT 'now'); insert into bar DEFAULT VALUES; insert into bar DEFAULT VALUES; insert into bar DEFAULT VALUES; insert into bar DEFAULT VALUES;
select * from BAR;
output:
date ---------------------------- 2004-02-12 15:17:38.838411 2004-02-12 15:17:38.838411 2004-02-12 15:17:38.838411 2004-02-12 15:17:38.838411
All rows have the same timestamp, as if 'now' was interpreted at the time of table creation, not at the time of insertion.
thanks,
Harry
Harry Hochheiser, Ph.D. Image Informatics and Computational Biology Unit Laboratory of Genetics NIH, National Institute on Aging 333 Cassell Drive Suite 3000 Baltimore MD 21224 410 558 8046
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
