grails postgres Message: ERROR: column this_.id does not exist

Question

grails with postgres for User domain.

 Message: ERROR: column this_.id does not exist

Answer 1

Got the issue. For User domain, I've postgres table as "user". So by default when it is trying to query user table, its not querying with "user.id". There is something wrong with postgres for "user" table.

So I updated my "user" table to "myapp_user" table. The problem got solved.