Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 557D3475B99; Sun, 3 Nov 2002 04:53:58 -0500 (EST) Received: from www2.tsenekov.com (unknown [64.246.22.23]) by postgresql.org (Postfix) with ESMTP id C8A38475B8E; Sun, 3 Nov 2002 04:53:57 -0500 (EST) Received: from kitezh.hq.taurussoft.org (ts31-b152.Moscow.dial.rol.ru [194.154.81.152]) (authenticated (0 bits)) by www2.tsenekov.com (8.11.6/8.11.6) with ESMTP id gA39vcX29302; Sun, 3 Nov 2002 12:57:42 +0300 Received: from flame-in-night.hq.taurussoft.org (flame-in-night.hq.taurussoft.org [192.168.107.1]) by kitezh.hq.taurussoft.org (Postfix) with ESMTP id 4B740584C5; Sun, 3 Nov 2002 12:53:26 +0300 (MSK) Received: from localhost (localhost [127.0.0.1]) by flame-in-night.hq.taurussoft.org (Postfix) with ESMTP id 099703F157; Sun, 3 Nov 2002 12:53:54 +0300 (MSK) Subject: uniqueidentifier datatype for 7.3.X From: "Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= =?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= =?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= To: psql-announce mailing list , =?koi8-r?Q?=F3=D0=C9=D3=CF=CB_?= =?koi8-r?Q?=D2=C1=D3=D3=D9=CC=CB=C9?= pgsql-sql Cc: Hussein Patni Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0 (Preview Release) Date: 03 Nov 2002 12:53:54 +0300 Message-Id: <1036317235.29799.34.camel@flame-in-night> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/3 X-Sequence-Number: 226 Hi All! I've ported uniqueidentifier datatype to upcoming PostgreSQL 7.3. It's available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.3.tar.gz In this release there is additional function uniqueidentifier_text() which converts uniqueidentifier to text datatype. Thanks to Hussein Patni! Version for 7.2.X is available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.2.tar.gz Version for 7.1.X is available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.1.tar.gz The only difference between two releases is adoptation to 7.2.X system catalog. No new functions/bugfixes. Uniqueidentifier datatype is 128-bit (16 byte) wide datatype claims to be unique across Universe. It's a good choice for primary indexes and making relations between tables. This inplementation depends on libuuid library from e2fsprogs package by Theodore Ts'o. Licence is LGPL. Regards, Dmitry