Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
question about default value and timestamp
- 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: Wed, 26 Jul 2006 07:26:09 +0200
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
- Follow-Ups:
- Re: question about default value and timestamp
- From: A. Kretschmer
- Re: question about default value and timestamp
- Prev by Date: Re: Executing an SQL query from an internal function...
- Next by Date: Re: question about default value and timestamp
- Previous by thread: Executing an SQL query from an internal function...
- Next by thread: Re: question about default value and timestamp
- Indexes: