Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly
Date: 2010-05-21 03:32:12
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting:

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

  Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
  Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
  Dim Tbl As New DataTable

When I inspect the values, they differ:


The original can be stored using the ODBC driver, it just seems to have trouble retrieving it.

Full connection string:

Driver={PostgreSQL ANSI};database=time_log;server=xxx.yyy.zzz.ttt;port=5433;uid=root;sslmode=allow;readonly=0;protocol=7.4-1;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=100;socket=4096;unknownsizes=0;maxvarcharsize=255;maxlongvarcharsize=8190;debug=0;commlog=0;optimizer=0;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=0;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;trueisminus1=1;bi=0;byteaaslongvarbinary=0;useserversideprepare=0;lowercaseidentifier=0;xaopt=1


Comment By: Philip Warner (pjw)
Date: 2008-11-01 12:14

Thanks for the quick response!

I tried the ASCII driver, and it worked, which is great!

How stable are the beta drivers? and/or any schedule for
releasing a production version?

Thanks again.


Comment By: Hiroshi Inoue (hinoue)
Date: 2008-10-31 22:04

Could you try the drivers on testing for 8.3.0300 dll at


You can respond by visiting:

pgsql-odbc by date

Next:From: noreplyDate: 2010-05-21 03:34:04
Subject: [ psqlodbc-Bugs-1010515 ] Small negative decimal values are mistaken for non-negative
Previous:From: noreplyDate: 2010-05-21 03:30:11
Subject: [ psqlodbc-Bugs-1010713 ] Bug with datatype lo and server side cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group