[BUGS] BUG #14755: unexpected error - Mailing list pgsql-bugs

From kes-kes@yandex.ru
Subject [BUGS] BUG #14755: unexpected error
Date
Msg-id 20170721145357.19351.224@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: zuberre@gmail.com
Date:
Subject: [BUGS] BUG #14754: ecpg SQL parsing error
Next
From: Greg Stark
Date:
Subject: Re: [BUGS] BUG #14754: ecpg SQL parsing error