default localtimestamp at time zone

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: default localtimestamp at time zone
Date: 2010-12-16 16:08:22
Message-ID: 1292515702.13736.2.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.)

Attachment Content-Type Size
default-localtimestamp-at-time-zone.patch text/x-patch 783 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-12-16 16:12:13 Re: [GENERAL] queriing the version of libpq
Previous Message Tom Lane 2010-12-16 16:07:56 Re: [GENERAL] queriing the version of libpq