Skip to content

NH-3545 - SchemaValidator fails for PostgreSql sequences #1163

Closed
@nhibernate-bot

Description

@nhibernate-bot

Tomas Sedlak created an issue — 1st October 2013, 14:31:20:

When validating schema in PostgreSql 9.2 the SchemaValidator throws <NHibernate.HibernateException> = {"Missing sequence or table: permissiontree_idgen"} exception.

To fix this issue I had to override QuerySequencesString in the PostgreSQL82Dialect class.

I created PostgreSQL92Dialect as a workaround for this issue.


Alexander Zaytsev added a comment — 1st October 2013, 21:16:23:

<~mrjoe>, a test case or at least a stack-trace would be useful.


Tomas Sedlak added a comment — 1st October 2013, 22:00:57:

Added simple test case.


chris_x added a comment — 28th January 2014, 12:39:08:

Having the same problem with PostgreSQL 9.3, using NHibernate.Dialect.PostgreSQLDialect. Your workaround (using custom PostgreSQL92Dialect) works for me.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions