UUID with variable length

From: Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: UUID with variable length
Date: 2020-10-15 20:49:49
Message-ID: AM0PR05MB6082166783DBD33747A49417E9020@AM0PR05MB6082.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have here a situation with the usage of UUID. Here the database user allows UUIDs with less then 16 byte lengths (please don't ask :-) ).

Of course there are some technical ways to do the filling of the not used bytes but I hope there is a better solution. This UUID is used
as primary Key and for indexing.

CHAR 16 is not preferred because of the risk of mistakenly changing the binary data.

Another option would be e.g. bytea but how is good would it work from a IO an latency perspective.

Or do you have some other ideas how to use a primary key datatype like UUID but with variable length?

Thanks

Dirk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dirk Krautschick 2020-10-15 20:58:13 Date Format 9999-12-31-00.00.00.000000
Previous Message Raj Iyer 2020-10-15 17:22:51 Question on postgres certified OS platforms