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

Search Discussions

  • Tom Lane at Dec 16, 2010 at 4:24 pm

    Peter Eisentraut 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedDec 16, '10 at 4:08p
activeDec 16, '10 at 4:24p
posts2
users2
websitepostgresql.org...
irc#postgresql

2 users in discussion

Peter Eisentraut: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2021 Grokbase