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.