`user` is a reserved keyword in postgres

[naved001]

If we use database authentication, then we create a table called user which happens to be a reserved keyword in postgres.

hil=> select * from user;
 current_user 
--------------
 hil
(1 row)

to get the correct response, I have to do select * from "user";

I guess we should avoid using reserved keywords. Don't know how big of an issue this is, might not be an issue at all, but I think it's worth discussing if something like this could lead to db problems in future.

[zenhack]

SQLAlchemy is smart enough to manage this, which is how it hasn't been raised thus far. I noticed this a while back, but I don't think it's a problem. I certainly don't think it's worth a migration script.

[naved001]

cool, I am gonna close this then.