Re: Time as keyword

I tried to create table foo (t time, time time); and received an error 
something like
'Error parsing near time'

I'm on 7.2.b2

I'll upgrade and try again.


Tom Lane wrote:

>Dwayne Miller  writes:
>
>>Did time become a keyword in 7.2? 7.1.3 allowed it as a column name... 
>>7.2 rejects it.
>>
>
>It's always been a keyword, but it is "more reserved" than it used to
>be.  See
>
>http://developer.postgresql.org/docs/postgres/sql-keywords-appendix.html
>
>However, according to that list TIME is still allowed as a column name,
>and indeed I get:
>
>regression=# create table foo (f1 time, time time);
>CREATE
>
>So I'm not sure what you did.
>
>			regards, tom lane
>