When validating schema in PostgreSql 9.2 the SchemaValidator throws [NHibernate.HibernateException] = {"Missing sequence or table: permission_tree_id_gen"} exception.
To fix this issue I had to override QuerySequencesString in the PostgreSQL82Dialect class.
I created PostgreSQL92Dialect as a workaround for this issue.
Having the same problem with PostgreSQL 9.3, using NHibernate.Dialect.PostgreSQLDialect. Your workaround (using custom PostgreSQL92Dialect) works for me.
Tomas Sedlak October 1, 2013 at 10:00 PM
Edited
Added simple test case.
Alex Zaytsev October 1, 2013 at 9:16 PM
@Tomas Sedlak, a test case or at least a stack-trace would be useful.
When validating schema in PostgreSql 9.2 the SchemaValidator throws [NHibernate.HibernateException] = {"Missing sequence or table: permission_tree_id_gen"} exception.
To fix this issue I had to override QuerySequencesString in the PostgreSQL82Dialect class.
I created PostgreSQL92Dialect as a workaround for this issue.