Date: Wed, 17 Mar 2010 11:29:23 -0500
To: pgsql-sql@postgresql.org
From: Michael Gould <mgould@intermodalsoftwaresolutions.net>
Subject: strange issue with UUID data types
Message-ID: <ff3fa5e776e6a57b7fd9cefe5aeecda2@intermodalsoftwaresolutions.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="b1_ff3fa5e776e6a57b7fd9cefe5aeecda2"


--b1_ff3fa5e776e6a57b7fd9cefe5aeecda2
Content-Type: text/plain; charset = "iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm running Windows 2008 64 bit server with Postgres 8.4.2 (also have =
tried
Windows 7 both 32 and 64 bit).=A0 The origin database is SQL Anywhere 10.


I've got several tables that have a UUID data type with
isscontrib.uuid_generate_v4() as the default value.=A0=20


All of the tables where these are the primary key work just fine and
properly create the UUID columns.


I also have several child tables that call into the parent table to return
the parent tables UUID.=A0 All of the child tables column which I'm =
returning
the parent tables UUID are defined as UUID data types and no default =
value.=A0
On all of my machines the UUID returned from the parent tables is always =
16
bytes, in fact the numbers are not truncated they don't make any sense or
pattern.


Now I would think that this could be a problem with my program not having
the proper length to hold the temporary data but I've also run this on 2
other machines, one through teamviewer to=A0 Windows 2008 standard server =
with
Postgres 8.4.2 loaded and it's schema's loaded from a pgdumpall.=A0=20


They are also running the same SQL Anywhere version 10 that we're =
converting
the data from.=A0 When we run the same code on that machine it runs =
properly
and the UUID returned is correct.=A0 I've tried this on his remote server =
and
it works.


Is there something I'm missing here?=A0 Is there somekind of environmental
parameter that I need to set?=A0 We've been scratching our heads over this =
for
about 10 days now trying to figure out why it works in one location and =
not
others.


Best Regards


Michael Gould


=A0


--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax


--b1_ff3fa5e776e6a57b7fd9cefe5aeecda2
Content-Type: text/html; charset = "iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<p>I'm running Windows 2008 64 bit server with Postgres 8.4.2 (also have =
tried Windows 7 both 32 and 64 bit).&#160; The origin database is SQL =
Anywhere 10.</p>
<p>I've got several tables that have a UUID data type with =
isscontrib.uuid_generate_v4() as the default value.&#160; </p>
<p>All of the tables where these are the primary key work just fine and =
properly create the UUID columns.</p>
<p>I also have several child tables that call into the parent table to =
return the parent tables UUID.&#160; All of the child tables column which =
I'm returning the parent tables UUID are defined as UUID data types and no =
default value.&#160; On all of my machines the UUID returned from the =
parent tables is always 16 bytes, in fact the numbers are not truncated =
they don't make any sense or pattern.</p>
<p>Now I would think that this could be a problem with my program not =
having the proper length to hold the temporary data but I've also run this =
on 2 other machines, one through teamviewer to&#160; Windows 2008 standard =
server with Postgres 8.4.2 loaded and it's schema's loaded from a =
pgdumpall.&#160; </p>
<p>They are also running the same SQL Anywhere version 10 that we're =
converting the data from.&#160; When we run the same code on that machine =
it runs properly and the UUID returned is correct.&#160; I've tried this =
on his remote server and it works.</p>
<p>Is there something I'm missing here?&#160; Is there somekind of =
environmental parameter that I need to set?&#160; We've been scratching =
our heads over this for about 10 days now trying to figure out why it =
works in one location and not others.</p>
<p>Best Regards</p>
<p>Michael Gould</p>
<p>&#160;</p><hr style=3D"border:dotted 1px silver; width:90%; =
border:dotted 1px silver;"><div>Michael Gould, Managing Partner<br />
Intermodal Software Solutions, LLC</div>
<div>904.226.0978</div>
<div>904.592.5250 fax</div>


--b1_ff3fa5e776e6a57b7fd9cefe5aeecda2--