lundi 20 avril 2015

Postgres 9.3.5 not accepting VARCHAR(MAX) GORM

I have a grails application that connects to a Postgres Plus Advanced Server. I have a domain in my grails application that has a column of sqlType: VARCHAR(MAX). When the table is created by GORM, the column with the sqlType: VARCHAR(MAX) were created as Text. But when I changed my database to use PostgreSQL 9.3.5, it fails to create the table and says that it is encountering syntax error. Is that one of the difference between Postgres Plus Advanced Server and PostgreSQL 9.3.5? If so, how can I handle this so I won't have to change codes since there are a lot of domains that is using sqlType: VARCHAR(MAX) in my application.

Thanks

Aucun commentaire:

Enregistrer un commentaire