Starting from H3.2 default behavior (in practices reverting r3020) and after some hours rethinking how resolve NH1155 I end to the same (more near to identical) solution applied for NH1155.
NH1155 introduce a NH specific feature and, in this case, NH behavior if better than Hb behavior; I don't want lost the feature.

I don't have Postgre but I think that the solution is more easy than I think when I start this work.
In practices I think that we only need to add an override of GetLimitString(SqlString, int, int).

What I saw in Hb is that not all dialect override that method; for example the FirebirdDialect in Hb don't override GetLimitString(SqlString, int, int) but we do it in NH and the two failed-tests of NH-1197 work fine with Firebird.
Probably the PostgreSQLDialect is too old in NH.

I'm going to leave a comment to the issue and hope somebody have Postgre can create a very simple patch overriding GetLimitString(SqlString, int, int) in PostgreSQLDialect.

--
Fabio Maulo

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php

_______________________________________________
Nhibernate-development mailing list
Nhibernate-development@(protected)
https://lists.sourceforge.net/lists/listinfo/nhibernate-development