[GUACAMOLE-345] Ensure SQL scripts are compatible with PostgreSQL 8

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Done
• Fix Version/s: 0.9.14
• Component/s: guacamole-auth-jdbc-postgresql
• Assignee: Mike Jumper
• Reporter: Mike Jumper
• Created: 15/Jul/17 20:40
• Updated: 24/Jul/17 17:37
• Resolved: 24/Jul/17 17:37

Description

Guacamole's SQL scripts are not compatible with PostgreSQL 8 due to the use of anonymous indices, hex binary literals, etc. While PostgreSQL 8 is EOL, a number of Linux distributions which are not EOL only provide support for PostgreSQL 8.

Guacamole's SQL scripts should be modified such that they run correctly on PostgreSQL 8 or later, rather than just PostgreSQL 9.