I have successfully created a datasource for my project, and completion (keywords, table names, column names etc) works well for database console. But I get no schema-related completion in my Spring JdbcOperations arguments. It still completes keywords (select, insert etc) and highlights it as sql, but no completion for table names, or column names. I have PostgreSQL dialect selected in datasource settings and "keywords only" in Settings -> SQL Dialects. Looks like that choosing Settings -> SQL Dialects -> PostgreSQL would fix the problem, but when I do that I lose keywords completion as well, i.e. I get no completion at all. And database console completions still work fine, table names etc are available.
IDEA 11.1.1, PostgreSQL 8.1 with postgresql-9.1-901.jdbc4.jar driver.