[sqlalchemy] getting error with column name end using geoalchemy2

Hi list, I am encountering a very strange error and I am scratching my head and got no idea what is going on. class Line(Base): __tablename__ = 'lines' id = Column(Integer, Sequence('line_id_seq'), primary_key=True) start = Column(Geometry('POINT'), nullable=False, *index=False*)

Re: [sqlalchemy] getting error with column name end using geoalchemy2

I once had a very strange error with a table called audit on an oracle database. It turned out, that exspecially on oracle audit was a reserved word - while it worked out fine on any other database. I would recommend trying to use other column names. As end is surrounded by double quites your

Re: [sqlalchemy] getting error with column name end using geoalchemy2

On 6/21/14, 8:34 AM, Chung WONG wrote: Hi list, I am encountering a very strange error and I am scratching my head and got no idea what is going on. class Line(Base): __tablename__ = 'lines' id = Column(Integer, Sequence('line_id_seq'), primary_key=True) start =

Re: [sqlalchemy] getting error with column name end using geoalchemy2

`END` is a reserved keyword in most SQL dialects, including the ANSI sql standards. I think mysql is the only major database that allows it. Here's a link to a collection of all known reserved keywords across databases, with links to relevant documentation for each particular standard.