-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 "option" as a reserved word was added at least at the very beginning of 0.6.
I'd advise upgrading, and Redhat shouldn't be at play here since you really shouldn't use distribution packages for Python libraries, there's a great discussion of this the other day at this post: http://hynek.me/articles/python-deployment-anti-patterns/ . On Apr 26, 2012, at 9:15 AM, Cornelius Kölbel wrote: > Dear list, > > I defined a table with a column, that is called "option". > I got a redhat 5 system with sqlalchemy 0.5.5. > When I try to do a > paster setup-app > > the machine tries to create the table which contains columns "default" > and "option", but it breaks with an ORA error "invalid identifier". > > It seems like this: "option" is a keyword in Oracle, and it does not get > enclosed in quotes. > I see that the other column "columnd" is enclosed in quotes. Obviously > sqlalchemy knows the keyword "default" and puts in in quotes. But it > does not seem to know the keyword "option" and does not put it in quotes. > > I think in newer versions this was fixed. Do you know in which version > of sqlalchemy started to see "option" as keyword? > > Kind regards > Cornelius > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (Darwin) Comment: GPGTools - http://gpgtools.org iQEcBAEBAgAGBQJPmalmAAoJEDMCOcHE2v7h3r4IANBeN58hi9PwXlbndCnIEsT+ Wh+TlmEfH2zKOA0nJkYIJUmWqGMZI1O3GL6BU56Pi1pZX4q4D09BP4J1JXo46+UW 8hEL5n0A0Ph5vfPy19z8tu2ZHjKAw374NsP2+Ak5Cu2J0DVKXWREWooDEKxG1cap +Z/bXTS3wKhR5Xs2N8WsQ9GsvT6cTHvmldIuPdEiTJapvucy7lBD+ksTxIOfenps f0pIs6N+HBQKOFkg73lx3Wbx3xKnopFlXLdpxWP7s7whHokcaQoNLodP6YyMNieL lsH6fpxK7D0YDpnG1DqpsjViiYkhHo53d0mVUHd07g2TRQLZ4Br1Y63ZGfqcvqM= =jan4 -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
