Author: steve.ebersole(a)jboss.com Date: 2009-06-05 10:04:57 -0400 (Fri, 05 Jun 2009) New Revision: 16706 Modified: core/trunk/core/src/main/java/org/hibernate/id/enhanced/TableStructure.java Log: HHH-3880 - org.hibernate.id.enhanced.TableStructure missing "as" keyword in select statment column renames; required for PostgreSQL Modified: core/trunk/core/src/main/java/org/hibernate/id/enhanced/TableStructure.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/id/enhanced/TableStructure.java 2009-06-05 13:53:08 UTC (rev 16705) +++ core/trunk/core/src/main/java/org/hibernate/id/enhanced/TableStructure.java 2009-06-05 14:04:57 UTC (rev 16706) @@ -68,7 +68,7 @@ this.incrementSize = incrementSize; this.valueColumnName = valueColumnName; - selectQuery = "select " + valueColumnName + " id_val" + + selectQuery = "select " + valueColumnName + " as id_val" + " from " + dialect.appendLockHint( LockMode.UPGRADE, tableName ) + dialect.getForUpdateString();