[SQL] uniqueidentifier datatype for 7.3.X
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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] Different size in the DATA directory
On Sat, Nov 02, 2002 at 08:20:04PM -0500, Bruce Momjian wrote: > Alexander M. Pravking wrote: > > As I see, contrib/reindexdb requires perl for commandline > > procesing. I don't think it's a good idea, since > > e.g. FreeBSD 5.0-CURRENT have no perl in standard distribution. > > > > Thomas, why not to use sed? > > No perl? I am no perl guy, but I assumed everyone had that already. > > I just looked at the code, and yes, it should use sed rather than perl, > especially since it is using it just for processing command line args. > > Seems it is a problem/bug for you. Patch applied to use sed rather than > perl. Well, I DO use perl, so it's not a problem for me :) But I see many people on these lists that do not. Thanks, Bruce. -- Fduch M. Pravking ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] uniqueidentifier datatype for 7.3.X
"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?= <[EMAIL PROTECTED]> writes: > In this release there is additional function uniqueidentifier_text() > which converts uniqueidentifier to text datatype. Thanks to Hussein > Patni! You would be better off to name the conversion function text(uuid) and declare it as a cast (possibly an explicit-only cast, depending on whether you think automatic casting of uuid to text is a good idea). Not following the standard naming convention for conversion functions just creates an extra memory burden for users. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] [PERFORM] Does this matter?
Thanks, I noticed that sweet addon and will try to integrate it into our system once 7.3 is officially released. :) btw, do we have a release date yet? Thanks Wei At 11:08 PM 11/3/2002 -0500, you wrote: Wei Weng <[EMAIL PROTECTED]> writes: > Since I need to use a GUID as the primary key, I have to use the char > datatype. Try uniqueidentifier: http://archives.postgresql.org/pgsql-announce/2002-07/msg1.php Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [SQL] uniqueidentifier datatype for 7.3.X
÷ ÷ÓË, 03.11.2002, × 19:08, Tom Lane ÎÁÐÉÓÁÌ: > "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?= <[EMAIL PROTECTED]> writes: > > In this release there is additional function uniqueidentifier_text() > > which converts uniqueidentifier to text datatype. Thanks to Hussein > > Patni! > > You would be better off to name the conversion function text(uuid) > and declare it as a cast (possibly an explicit-only cast, depending on > whether you think automatic casting of uuid to text is a good idea). > Not following the standard naming convention for conversion functions > just creates an extra memory burden for users. > Thanks, Tom. I thought about it but I should consult with doc how to do so. Now I simply add Hussein's function to the package because my task was to port datatype itself. Regards, Dmitry ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
