Thread: is limit a reserved keyword?

I have a piece of commercial software that does a query like so:
CREATE TABLE chargelimits (id int NOT NULL, user_id int NOT NULL, limit 
float NOT NULL )
but the postgresql 7.0 gives a parse error near "limit".
Is limit a reserved keyword?
If so, then it is not in the list of reserved keywords.
Is there a way that I can make this query run without altering it?

ThanksGabriel Russellg.russell@ieee.org

Gabriel Russell <g.russell@ieee.org> writes:
> Is limit a reserved keyword?

Yes.

> If so, then it is not in the list of reserved keywords.

Documentation oversight, evidently :-(
        regards, tom lane