Обсуждение: [BUGS] BUG #14755: unexpected error

The following bug has been logged on the website:

Bug reference:      14755
Logged by:          Eugen Konkov
Email address:      kes-kes@yandex.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


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs