Added to TODO: * Allow the UUID type to accept non-standard formats http://archives.postgresql.org/pgsql-hackers/2008-02/msg01214.php
--------------------------------------------------------------------------- Dawid Kuroczko wrote: > Hello. > > I am currently playing with UUID data type and try to use it to store provided > by third party (Hewlett-Packard) application. The problem is they > format UUIDs as > 0000-0000-0000-0000-0000-0000-0000-0000, so I have to > replace(text,'-','')::uuid for > this kind of data. > > Nooow, the case is quite simple and it might be that there are other > applications > formatting UUIDs too liberally. > > I am working on a patch to support this format (yes, it is a simple > modification). > > And in the meanwhile I would like to ask you what do you think about it? > > Cons: Such format is not standard. > > Pros: This will help UUID data type adoption. [1] While good > applications format > their data well, there are others which don't follow standards. Also > I think it is > easier for a human being to enter UUID as 8 times 4 digits. > > Your thoughts? Should I submit a patch? > > Regards, > Dawid > > [1]: My first thought when I received the error message was "hey! this > is not an UUID, > it is too long/too short!", only later did I check that they just > don't format it too well. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your Subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers