> -----Original Message----- > From: frank_lupo [mailto:[EMAIL PROTECTED] > Sent: 28 May 2003 12:56 > To: Dave Page > Cc: ian.brown; pgadmin-support; franklupo > Subject: RE: [pgadmin-support] Error Message > > > Hi Dave, > > > > >>Insert your comment: > >>The above error is generated by clicking the 'view' toolbar > button on a table of mine called user. I can >>get the same > error using the SQL winodow... > >>In the SQL window: > >>select * from user > >>gives the error, but > >>select * from "user" > >>works okay. > > >Hi, > >The problem is that user is a reserved word because it is > part of the > >SQL syntax. It's usually best to >avoid reserved words for > object names, though I appreciate that's not always easy, or > what you want. > >Frank: It seems to me that the best solution might be to > maintain a list of reserved words and add a >check in fmtID > to make sure the word is not in the list. What do you think? > >Regards, Dave > > > In fmtID why do not escape always ? >
That's how we used to do it but it looks *very* messy and can make statements almost unreadable. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
