Actually, we can use the Adaptors to hold specific keywords. So in DAL.__init__ can have for fields if fieldname in self._adapter.KEYWORDS then raise SyntaxError
-Thadeus On Tue, Feb 2, 2010 at 11:28 AM, Thadeus Burgess <thade...@thadeusb.com> wrote: > Massimo, is there a better place (in dal.py) to place this check. The > most logical I see is the Field.__init__ constructor. > > -Thadeus > > > > > > On Tue, Feb 2, 2010 at 11:27 AM, Thadeus Burgess <thade...@thadeusb.com> > wrote: >> I am working on this, I am integrating a list of reserved words into >> the Field() class. >> >> For now just the common SQL keywords, which I'm sure can be extended >> to include backend-specific keywords. >> >> -Thadeus >> >> >> >> >> >> On Tue, Feb 2, 2010 at 11:08 AM, baloan <balo...@googlemail.com> wrote: >>> Thanks David for the reference. >>> >>> Btw, DATE is not marked as a reserved keyword on PostgreSQL and I can >>> create DATE columns using SQL or the admin tools (pgadmin). >>> >>> Consequently I was doubly confused as DATE appears as a web2py >>> reserved word to me. >>> >>> @Massimo: in your leisure time ;-) you may consider to change the >>> ProgrammingError exception to give a hint I used a "web2py/SQL >>> reserved word". >>> >>> Regards, Andreas >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "web2py-users" group. >>> To post to this group, send email to web...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> web2py+unsubscr...@googlegroups.com. >>> For more options, visit this group at >>> http://groups.google.com/group/web2py?hl=en. >>> >>> >> > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.