| From: | kes-kes(at)yandex(dot)ru |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | kes-kes(at)yandex(dot)ru |
| Subject: | BUG #14755: unexpected error |
| Date: | 2017-07-21 14:53:57 |
| Message-ID: | 20170721145357.19351.224@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14755
Logged by: Eugen Konkov
Email address: kes-kes(at)yandex(dot)ru
PostgreSQL version: 9.6.1
Operating system: Linux mint 18: Linux work 4.4.0-57-generic #78-Ubu
Description:
SELECT me.id, me.user_id, me.role_id FROM users_roles me JOIN users user ON
user.id = me.user_id JOIN roles "Role" ON "Role".id = me.role_id;
ERROR: syntax error at or near "user"
LINE 1: ...er_id, me.role_id FROM users_roles me JOIN users user ON us...
^
I undestand that 'user' is conflict with reserved word 'user', but why
'syntax error' I can not explain
I think this error message should be clarified
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2017-07-21 15:56:59 | Re: BUG #14754: ecpg SQL parsing error |
| Previous Message | zuberre | 2017-07-21 14:16:40 | BUG #14754: ecpg SQL parsing error |