Hi,

I am using Postgresql(8.3) - database.
NHibernate (2.1.0.4), npgsql 2.0.6.0 and
.net 3.5

I am trying to use guid fields as my primary key in tables. Ideally i would expect uuid field in PostGreSql database to be equivalent of Guid type in .net

IList<FeatureTimeSeries> listOfFeatureTimeSeries;

using (ISession session = ConnectionUtility.OpenSession())
{
try
{
listOfFeatureTimeSeries = session.CreateQuery("FROM FeatureTimeSeries fts WHERE fts.FeatureId = " +/* "'" + */guid/* + "'"*/).List<FeatureTimeSeries>();

session.Flush();
}
catch (Exception ex)
{
throw ex;
}
}

but when i use this mapping then i get below message, while creating session object.

_sessionFactory = configuration.BuildSessionFactory();

Dialect does not support DbType.Guid
Parameter name: typecode

Up. The same problem.

I had the same problem.

The fix was to change "NHibernate.Dialect.PostgreSQLDialect" to "NHibernate.Dialect.PostgreSQL82Dialect" in the config file.

I figured this out by reading this bug: http://nhjira.koah.net/browse/NH-1111

Thanks! That works.

Could some one suggest how to do it in Java with Hibernate mapping file?

I Just want to auto generate a column with type guid.