Re: Error Message

>
>
> > -----Original Message-----
> > From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> > 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 seem
s to me

t
hat 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.
>

Hi Dave,

Ok, you have reason, I will create reserved words.

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Hai bisogno di riorganizzare la tua agenda? Risolvi il problema con un nuovissimo palmare!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=762&d=28-5