question about default value and timestamp

Started by Christian Rengstlover 19 years ago2 messagesgeneral

Christian.Rengstl@klinik.uni-regensburg.de

over 19 years ago

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

A. Kretschmer

andreas.kretschmer@schollglas.com

over 19 years ago

In reply to: Christian Rengstl (#1)

Re: question about default value and timestamp

am 26.07.2006, um 7:26:09 +0200 mailte Christian Rengstl folgendes:

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

No, but when the _Transaction_ starts. You can use timeofday() instead.

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===