Problems using Grails with Postgresql - Mailing list pgsql-general

i am using postgresql instead of mysql ,but while execute i am getting error
like


Caused by: org.codehaus.groovy.runtime.InvokerInvocationException:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query


my codings in datasource:


dataSource {
    pooled = false

     driverClassName = "org.postgresql.Driver"
    username ="sa"
    password =""
}
hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true

cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'

}
// environment specific settings
environments {
    development {
        dataSource {

            dbCreate = "update" // one of 'create', 'create-drop','update'
                  url ="jdbc:postgresql://localhost:5432/test"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
            url = "jdbc:hsqldb:mem:testDb"

        }
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:hsqldb:file:prodDb;shutdown=true"

        }
    }
}
pls help me to execute
--
View this message in context: http://www.nabble.com/Problems-using-Grails-with-Postgresql-tp18565587p18565587.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.