| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Mark Hollomon <mhh(at)nortelnetworks(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Bug with views and defaults |
| Date: | 2000-06-17 00:06:49 |
| Message-ID: | 200006170006.UAA06645@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> This is a known and not readily fixable problem. It's far safer
> to write the default for a timestamp column as now(), rather than
> relying on a string literal not getting coerced to timestamp form
> too soon. See
> http://www.postgresql.org/mhonarc/pgsql-hackers/1999-10/msg00036.html
>
> BTW, Bruce: it probably would be wise to have the FAQ's item 4.22
> recommend now() and nothing else. 'now' has nothing much to recommend
> it and there are still pitfalls like this one.
>
> regards, tom lane
>
TODO updated.
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-06-17 00:08:21 | Re: Big 7.1 open items |
| Previous Message | Tom Lane | 2000-06-16 23:43:10 | Re: Bug with views and defaults |