This is firmly in the “putting it up here just in case anyone else has the same problem” category. There is a gotcha that bites when writing a Grails application that uses the acegi security plugin along with a postgresql database as the data source. The problem is that the acegi plugin will, by default, create a domain class with the name
User. When you try to run the application with a postgresql datasource, GORM will try to create a table with the name
user, which postgresql will not like as it is a reserved word.
This is a particularly ...more ...