From: | frank_lupo <frank_lupo(at)email(dot)it> |
---|---|
To: | dpage <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | ian(dot)brown <ian(dot)brown(at)printsoft(dot)de> |
Subject: | Re: Error Message |
Date: | 2003-05-28 15:57:14 |
Message-ID: | HFLTNE$0DF210411FAC5BF48C656D56E5677830@email.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
>
>
> > -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-05-28 16:00:04 | Re: Error Message |
Previous Message | Dave Page | 2003-05-28 15:19:13 | Re: Error Message |