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: | Raw Message | Whole Thread | 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 |