Horton

Re: Bug with views and defaults

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Mark Hollomon <mhh@nortelnetworks.com>, pgsql-hackers@postgreSQL.org
Date: 2000-06-17T00:06:49Z
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026