Error when saving configuration to postgres

[otterc]

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "user"
Position: 82
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:138) ~[postgresql-9.4.1211.jre7.jar!/:9.4.1211.jre7]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[hibernate-core-4.3.11.Final.jar!/:4.3.11.Final]

[tgianos]

Confirmed this is an issue with Postgres 3.0.0 schema and code. Unfortunately updating @Column definition to "\"user\"" solves the issue for Postgres but creates issues in other stores. It makes more sense at this point to fix this issue by renaming the column to genie_user instead of constantly fighting against reserved keywords and workarounds.

[tgianos]

@otterc This issue should be fixed in release 3.0.1 with the new schema. I ran all the integration tests against both MySQL and PostgreSQL and everything passed. There are database upgrade scripts or entirely new schema files as well. I'll cherry-pick this into master as well so that the same fix will be in going forward.