Skip site navigation (1) Skip section navigation (2)

Re: Error Message

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 (view raw or flat)
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

pgadmin-support by date

Next:From: Dave PageDate: 2003-05-28 16:00:04
Subject: Re: Error Message
Previous:From: Dave PageDate: 2003-05-28 15:19:13
Subject: Re: Error Message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group