Postgres Pro
Downloads
Home   >   mailing lists

question about default value and timestamp - Mailing list pgsql-general

From Christian Rengstl
Subject question about default value and timestamp
Date
Msg-id 44C7190F.0AD0.0080.0@klinik.uni-regensburg.de
Whole thread Raw
Responses Re: question about default value and timestamp  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Executing an SQL query from an internal function...
Next
From: "A. Kretschmer"
Date:
Subject: Re: question about default value and timestamp