question about default value and timestamp

Hi list,

i have a table with a column where the default value is current_timestamp, but somehow all the tuples (around
8.000.000)have the same timestamp, which is, honestly speaking, not what i intended to do. So is the current_timestamp
functiononly executed when the insert statement starts? I mean of course i can change it and insert the
current_timestampexplicitly in every tuple, i just would like to know why it doesn't work the way i wanted it to
work...

Thanks!
Chris

--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230