Timestamp is a reserved word. You are a naughty person for using it
:). However, I think that you will find that:
CREATE TABLE test ("timestamp" timestamp);
Works just fine.
Jason
Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:
> The parser seems to have changed from 7.1.3->7.2B2 in a bad way:
>
> test=# create table test(timestamp timestamp);
> ERROR: parser: parse error at or near "timestamp"
>
> Don't-ever-say-I-didn't-test-B2,
> -Kevin
>
> PS: CC me on the results, and let me know if there is a better place to
> submit bugs. There didn't seem to be anything obvious on the developer
> site.
>
> --
> Kevin Jacobs
> The OPAL Group - Enterprise Systems Architect
> Voice: (216) 986-0710 x 19 E-mail: jacobs@theopalgroup.com
> Fax: (216) 986-0714 WWW: http://www.theopalgroup.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)