From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "frank_lupo" <frank_lupo(at)email(dot)it> |
Cc: | "ian(dot)brown" <ian(dot)brown(at)printsoft(dot)de>, "pgadmin-support" <pgadmin-support(at)postgresql(dot)org>, "franklupo" <franklupo(at)pgadmin(dot)org> |
Subject: | Re: Error Message |
Date: | 2003-05-28 12:05:11 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B825A235@mail.vale-housing.co.uk |
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 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Marcia Bussolaro | 2003-05-28 14:42:29 | Error Message |
Previous Message | frank_lupo | 2003-05-28 11:56:00 | RE: Error Message |