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
function only executed when the insert statement starts? I mean of course i can
change it and insert the current_timestamp explicitly 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
