Thread

1. default localtimestamp at time zone

   Peter Eisentraut <peter_e@gmx.net> — 2010-12-16T16:08:22Z

   Oddly, this doesn't work:
   
   create table test (x timestamp default localtimestamp at time zone 'UTC');
   ERROR:  42601: syntax error at or near "at"
   
   (Parentheses help.)
   
   The attached patch fixes it.  Is there any reason for this omission?
   
   (The patch also works in past releases, so it was not obviously a parser
   problem.)
   

2. Re: default localtimestamp at time zone

   Tom Lane <tgl@sss.pgh.pa.us> — 2010-12-16T16:24:11Z

   Peter Eisentraut <peter_e@gmx.net> writes:
   > Oddly, this doesn't work:
   > create table test (x timestamp default localtimestamp at time zone 'UTC');
   > ERROR:  42601: syntax error at or near "at"
   
   > (Parentheses help.)
   
   > The attached patch fixes it.  Is there any reason for this omission?
   
   I'm not really thrilled about adding low-usage options to b_expr.  That
   could back us into a corner later, by preventing b_expr from being used
   in someplace where it'd be desirable.
   
   			regards, tom lane