BUG #14755: unexpected error

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

Browse pgsql-bugs by date

  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