GnuCash GUIDs vs. RFC 4122 UUIDs

Derek Atkins warlord at MIT.EDU
Tue Feb 9 09:16:38 EST 2010


Hi,

Robert Fleming <fleminra at gmail.com> writes:

> Hi,
>
> I have my GnuCash data in a PostgreSQL database, using GnuCash 2.3.8.  I'm
> writing/using external programs (Python) to manipulate the data, including
> inserting new data.  It is cumbersome for that software to invoke
> gnucash-make-guids to make the new GUIDs.
>
> Do you think there would be any risk if my programs used RFC 4122 UUIDs
> instead?  I presume not, because even if there were a collision, data
> integrity would be preserved by the PRIMARY KEY constraints on each table.

You have a 1 in 2^128 chance of picking the same UUID.  However, note
that we do NOT support you adding data to the database, and you are
likely to cause the data to become "invalid" in GnuCash's eyes.  YMMV,
but you have been warned.  If gnucash fails to read your data or gives
you bogus results it's your own fault ;)

> Thanks in advance,
> Robert

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list