pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedstrange issue with UUID data types
3+ messages / 2 participants
[nested] [flat]
* strange issue with UUID data types
@ 2010-03-17 16:29 Michael Gould <mgould@intermodalsoftwaresolutions.net>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Gould @ 2010-03-17 16:29 UTC (permalink / raw)
To: pgsql-sql
I'm running Windows 2008 64 bit server with Postgres 8.4.2 (also have tried
Windows 7 both 32 and 64 bit). 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.
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. All of the child tables column which I'm returning
the parent tables UUID are defined as UUID data types and no default value.
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 Windows 2008 standard server with
Postgres 8.4.2 loaded and it's schema's loaded from a pgdumpall.
They are also running the same SQL Anywhere version 10 that we're converting
the data from. When we run the same code on that machine it runs properly
and the UUID returned is correct. I've tried this on his remote server and
it works.
Is there something I'm missing here? Is there somekind of environmental
parameter that I need to set? 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
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: strange issue with UUID data types
@ 2010-03-17 16:42 Rob Sargent <robjsargent@gmail.com>
parent: Michael Gould <mgould@intermodalsoftwaresolutions.net>
0 siblings, 1 reply; 3+ messages in thread
From: Rob Sargent @ 2010-03-17 16:42 UTC (permalink / raw)
To: pgsql-sql
On 03/17/2010 10:29 AM, Michael Gould wrote:
> I'm running Windows 2008 64 bit server with Postgres 8.4.2 (also have
> tried Windows 7 both 32 and 64 bit). 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.
>
> 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. All of the child tables column which I'm
> returning the parent tables UUID are defined as UUID data types and no
> default value. 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 Windows 2008
> standard server with Postgres 8.4.2 loaded and it's schema's loaded from
> a pgdumpall.
>
> They are also running the same SQL Anywhere version 10 that we're
> converting the data from. When we run the same code on that machine it
> runs properly and the UUID returned is correct. I've tried this on his
> remote server and it works.
>
> Is there something I'm missing here? Is there somekind of environmental
> parameter that I need to set? 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
Given my recent history re: uuid's perhaps I shouldn't chime in here,
but can't help myself.
get/run pg_config to see how postgres was built and installed. It may
be using ossp uuid support?
2. Are all the uuid libraries 64 bit?
3. Has the programme been migrated from 32 bit?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: strange issue with UUID data types
@ 2010-03-17 19:18 Michael Gould <mgould@intermodalsoftwaresolutions.net>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Gould @ 2010-03-17 19:18 UTC (permalink / raw)
To: pgsql-sql
"
> Given my recent history re: uuid's perhaps I shouldn't chime in here,
> but can't help myself.
>
> get/run pg_config to see how postgres was built and installed. It may
> be using ossp uuid support?
I ran this and it showed that ossp uuid were turned on. This build is the
windows installer from EnterpriseDB
> 2. Are all the uuid libraries 64 bit?
I'm not sure what EnterpriseDB uses and I'm not sure what difference this
would make. I can't get it to work on either 32 bit or 64 bit Windows
platforms.
> 3. Has the programme been migrated from 32 bit?
The program is a Win32 program
Best Regards
Mike Gould
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-03-17 19:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-17 16:29 strange issue with UUID data types Michael Gould <mgould@intermodalsoftwaresolutions.net>
2010-03-17 16:42 ` Rob Sargent <robjsargent@gmail.com>
2010-03-17 19:18 ` Michael Gould <mgould@intermodalsoftwaresolutions.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox