| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: question about default value and timestamp |
| Date: | 2006-07-26 05:42:26 |
| Message-ID: | 20060726054226.GC14663@webserv.wug-glas.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alan | 2006-07-26 06:44:35 | Re: Invalid column display size. Cannot be less than zero |
| Previous Message | Christian Rengstl | 2006-07-26 05:26:09 | question about default value and timestamp |