From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Ian Brown" <ian(dot)brown(at)printsoft(dot)de>, <pgadmin-support(at)postgresql(dot)org> |
Cc: | <franklupo(at)pgadmin(dot)org> |
Subject: | Re: Error Message |
Date: | 2003-05-28 11:16:58 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B83AF0D4@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | frank_lupo | 2003-05-28 11:56:00 | RE: Error Message |
Previous Message | Ian Brown | 2003-05-28 10:11:48 | Error Message |