| From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | question about default value and timestamp |
| Date: | 2006-07-26 05:26:09 |
| Message-ID: | 44C7190F.0AD0.0080.0@klinik.uni-regensburg.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-07-26 05:42:26 | Re: question about default value and timestamp |
| Previous Message | Alvaro Herrera | 2006-07-25 23:31:58 | Re: Executing an SQL query from an internal function... |