[nhibernate-issues] [JIRA] Commented: (NH-1111) PostgreSQL 8.3 dialect with Guid type support

[NHibernate J. <mik...@us...>]

    [ http://jira.nhibernate.org/browse/NH-1111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_15907 ] 

David Bachmann commented on NH-1111:
------------------------------------

PostgreSQL 8.3 supports GUID type by providing a new native type named UUID.
http://developer.postgresql.org/pgdocs/postgres/datatype-uuid.html

SQL queries like this one are now possible:
select * from foo where foo.uuid_field = '01234567-abcd-abcd-abcd-0123456789ab';

I've submitted a patch to Npgsql to add this new feature. It has been approved and applied on the CVS repository of Npgsl2:
http://pgfoundry.org/tracker/index.php?func=detail&aid=1008782&group_id=1000140&atid=592
http://lists.pgfoundry.org/pipermail/npgsql-devel/2007-September/000381.html

Every unit tests who failed with error 'Dialect does not support DbType.Guid' are now successfully passing.
Furthermore I've added a test to verify that GUID type are correctly supported in a where clause. (see attached patch)

Tests were done on Windows XP against PostgreSQL-8.3-dev1 (Windows binary version from PgInstaller: http://pgfoundry.org/projects/pginstaller/ ) using current CVS version of Npgsql2.

> PostgreSQL 8.3 dialect with Guid type support
> ---------------------------------------------
>
>                 Key: NH-1111
>                 URL: http://jira.nhibernate.org/browse/NH-1111
>             Project: NHibernate
>          Issue Type: New Feature
>          Components: Data Providers
>    Affects Versions: 2.0.0.Alpha1
>            Reporter: David Bachmann
>         Attachments: PostgreSQL83Dialect.cs
>
>
> Next version of PostgreSQL, 8.3, will support DbType.Guid.
> This new dialect add this functionality.
> It was not tested because Npgsql currently doesn't recognise DbType.Guid. But, except a big surprise, this should work like a charm.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira