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