Re: default localtimestamp at time zone

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-16T16:24:11Z
Lists: pgsql-hackers
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