Thread: uniqueidentifier

I can't help you with a Postgres equivalent for the uniqueidentifier datatype.  However, when it comes to migrating
yourexisting data the binary type migration is not very straightforward.  I'm not even sure that uniqueidentifier IS a
binarytype....it's hard to tell exactly from the SQL Books Online.  But if you get to that point and you've got
problems,drop me an email and I'll tell you how I migrated VARBINARY data from MSSQL to Postgres.
 
 
Roman Fail
Sr. Web Application Developer
POS Portal, Inc.

    -----Original Message----- 
    From: Mark Leicester [mailto:mark.leicester@energyintellect.com] 
    Sent: Wed 1/15/2003 10:01 PM 
    To: pgsql-general@postgresql.org 
    Cc: 
    Subject: <no subject>
    
    

    Hi there,
    I've successfully installed Postgres 7.3.1 on MAC OS X 10.2.3 and am keen to
    get started porting some MSSQL databases to Postgres.
    The problem I have struck is that there is no equivalent to MSSQL's
    uniqueidentifier datatype in Postgres.
    I have seen the implementation for Linux at http://www.taurussoft.org/ but
    that relies on the e2fs libraries for uuid generation.
    Has anyone ported the uniqueidentifier for the Mac, or can anyone give me
    tips on plugging the linux implementation into the mac uuid libraries.
    Thanks in advance,
    Mark.
    
    

I don't know if this is the same as what you are after but there is a
project on gborg...

http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php

But from the description it may have the same trouble as regards to e2fs as
you mention....

HTH

Adam


> Hi there,
> I've successfully installed Postgres 7.3.1 on MAC OS X 10.2.3 and am keen to
> get started porting some MSSQL databases to Postgres.
> The problem I have struck is that there is no equivalent to MSSQL's
> uniqueidentifier datatype in Postgres.
> I have seen the implementation for Linux at http://www.taurussoft.org/ but
> that relies on the e2fs libraries for uuid generation.
> Has anyone ported the uniqueidentifier for the Mac, or can anyone give me
> tips on plugging the linux implementation into the mac uuid libraries.
> Thanks in advance,
> Mark.
>



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.