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

Odd UUID behaviour

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Odd UUID behaviour
Date: 2008-10-28 14:18:08
Message-ID: 49071F20.8020401@rhyme.com.au (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

I submitted this at pgFoundry...not sure which is the correct place.

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
  DA.Fill(zTbl)

When I inspect the values, they differ:

  ?tbl.Rows(0).Item(0).ToString
  "e964684f-87fe-49d9-9b87-137cc83165ea"
  ?tbl.Rows(0).Item(1).ToString
  "00390065-0036-0034-3600-380034006600"

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

Running under XP SP3, 32 bit talking to a 32 bit linux server.

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;s
howoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=100;socket=4096;unknownsizes=0;maxvarcharsize=255;maxlongvarcharsi
ze=8190;debug=0;commlog=0;optimizer=0;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=0;p
arse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;trueisminus1=1;b
i=0;byteaaslongvarbinary=0;useserversideprepare=0;lowercaseidentifier=0;xaopt=1



-- 
----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 03 5330 3171          |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
http://www.rhyme.com.au <http://www.rhyme.com.au/>
|                /           \|
                                 |    --________--
GPG key available upon request.  |  /
                                 |/


pgsql-odbc by date

Next:From: noreplyDate: 2008-10-31 22:04:41
Subject: [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly
Previous:From: noreplyDate: 2008-10-28 14:09:43
Subject: [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

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