Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPhpU-0005Xp-NM for pgsql-jdbc@arkaria.postgresql.org; Wed, 08 Feb 2023 10:37:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPhpT-00057M-JG for pgsql-jdbc@arkaria.postgresql.org; Wed, 08 Feb 2023 10:37:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPhpT-00051z-0t for pgsql-jdbc@lists.postgresql.org; Wed, 08 Feb 2023 10:37:31 +0000 Received: from sonic306-19.consmr.mail.ir2.yahoo.com ([77.238.176.205]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pPhpL-0005gF-M0 for pgsql-jdbc@postgresql.org; Wed, 08 Feb 2023 10:37:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.fr; s=s2048; t=1675852640; bh=uPlbov71V9Mmc5K/fxFnBFZkaqDYU9lCFZQC03hzbk4=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=giUdeO7ZVosRtepPZnp8geoPCM7yCOR+VNcD6euRqW8SdFC7UhfygQZhiDYcBa+FWL70JRFzf9AC8R4LKVu2J6pOdwc4BldLBlj1h4Hdl/nZkGpqm4PL8wF85E3BvbJHvVRzEh7HTHbKaD8CQ+FVekOUHhqCfQv1UXng6SkbLNFTt0B79TvxttoCSILmEklSWd6K5EvqgzeMzPMqwSzWRUFTXyGTfehEm1309AbgODl7b89PWCW3D5vAAbs+wvHm79irWro56RfE4De50+i19G+kAe8sgw1jjrN1hhKJB4dgeSXTab1cRfP9qIjx0EBYQ8Zhg5UtEI5Tql7IWmcbrQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1675852640; bh=ue05aJSKj4evXHf3uzDsWUjSE9g5immECIsVkmckSgo=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=GtaWo2OPXV7ajNBzmwc4cREHTbWctHqu76fMLMaG49jPmNu5fJmZNNE7dtNQfQTMyWbNLjVvMj/Ad0xrkc4rv71KQrwxw2TfnFu4TvypPayizZmtuzwO9Yw3uyRHOZPogxhLe9rEm04o/7Lw3GLT8OqGWIK5HGGt78geNw6NUFXd5G9OrnveUHlznjAYibuCWv697FOuVvJlx4dohlmE+8xqyAw7frEFknsSys6EKlszlzf/NaY/QdVVG7pMRB5AwFmvlXolcodYfGzZaWALPrAnfd29EfRS8BMxUoG3kljxrRyH4q5J7BoX71hnfE6rxEnlnhyXSw6mNuWg8f6URA== X-YMail-OSG: iFQhbo8VM1kssQj0xVdU7bKRReQ0KkxSEohLV3nfOkB99Ner4GYxx3ipDBE3.6g uyG0RfiCib0ei.ctWHCd8MWLb4y5TWFEhZj7Nx73e2d7QSlClmWPC8l_6Gm9XfSagEq35JxavuJS DkTWYsXHiEyHnhvZEbFXL5zpL27U0b1fuTo9gNLIbwGSs80L.dEILoW5VMMlWmZSIiOv4ewVr0T4 fhpu3hzzIoHChArNTv07Tf6KKq55X3xF9ujN.fQHfXQyUheKH4O9e55bBX9Oe83E5QHs17IL.dLy x_xucwU5dCdqoL5XIiva3FB6vSBex8PAf.mu3iCAun0lD5SyG4hYJdwwYeoxIlluFd6J3Ii9lAct B_puoEpwc9XpTAUd81Ft3Emiimj23I99Tr6L4E2TXYtmVPGRornENkylZyucrQuqLTblb3RGDSa3 72qLrd_pILQbjDRjrqgK6nmGQwKlr.rQI4zrEWfosFJkjvVRCli9xsMgiK0xUBpDGd1A7imV1E6h DnVM1K_SV3yVhxnEApoar5omAt_Rwh8oU9seZC5WO8sctUsnNA83fx6b0_EpiS5cWmi4ZjRxCXw4 nasuWOlZ.oc617BPwpr67Kri5XMm8JL7slGDCJMmH1BPKPnYIiWNJIs_X.yhuZtE7gcbk0I5HNzK usy4YcZnRV.On2U94mcS6KD0K8aB7LS9DrhXSSM7OOfE0Q4.9hQxE5m5NcYHOa3RYFv6bFFIzTNE pKsVmCnf0.ckmp.iRwnNBwa2ExwCGr4F.G5CGHmXzwimJZ0bPjlP2yZR3dUijGzDc73ihvtS.JyH 6RHx0c46_I1jXC.EpL3OXarIb7jso_2L6aq9mFNqFgJ2u6jkb2ykIzHo4ruFDmNBLTfzRpKARwmE X9Ie9l8xTbbsgnRaAeW1h3UBPXFi7dJOm18NLy97szf9NlbS_Jeh9nKJ9bsSPlFyYEZaidpr_45u WhMFsynxzw2FHhI8hnp5kwUg3TX2nb5B.gHxMig4THNgP9HT.gdQW9.d0ZpAPlGVd9XteF88MgSg HqDU0DkElR8q4JWSg1XPnuCVxISAjEX0Dok8RIH8YTZ26AvOaXx8RcHz3Ww.FWqblOspcrioQQ1g 3nPGdzCVJHXk8pBpSJDqfcIregoSU_iSxQXh5bvqRa7MFvYJc7zDQIBJ_zymEomFVBxUMQcNPVfX EqgrKxpMsdukikl5e0IYbUj2IPb4q2N_c.B1goUDF7VxMJi8Rj187l5eDXp1TnJaTV1jQb0HRVKM DVcOU1oxM3WB9cbmQqlNBjqE84QMyIUB0DGwJuyYjdc8AWR1S2xVgd3SKhSWAENKGWOq36DWqn9Q d1GNSqz7gylg4u04haYAwv0h2YHhOYNgrqMu4n.9Y8kPFoSqqMovljhLs7N3Wy_FqVN4LTI2pab. gqe_3SqIQutoIUXGOz6T4tQY83ftB0Mi18phMaRdHOKVuGJJ6DDEZ73npKZ8.iX5PDlAehS6uVYs .b9OvqMDmzOu0BnPnvKRsAABLSKX.erNRFnUofwH8FWALBXxeymqnoqbEBhs_huu5IoiZrvAwzR7 Vpoxi7_F6Op7uwnBmyOlCnNEPyNsIbwOiii_yANnKBJCMWcJq0NYXOusZIeCcsOzwv8.hPRvg01. d.8YLDOBOhoAUuEMiOu5NslSC3EXvar_tkcoEaVhOtj7obqL79rQFx0wv53Yr3Q_sYJmdqnwGPhg uHs2PmOXH6MzVS9s6w5n3F20xR6fqmz.2ed_L0_N9Akv_SLbDFuteeYNDWcUZ8xjEmwI1M531Iop of56av411TlEowe8JGKBPcokCS18SkYMTZw56qzkLE2h7pOyzrXpEbKqWSvn8cQmodpwofekJ1Vh 7varYIFlJE_r4Q22_8kRCqWqE8cMrUEZC3iDueX6RMhpKtmamx6.a0CrzhhPw_91jprkC4717RaL 1xCrqyIv21Yr8WcD13RGAOeEXJ7ZLZNRD6.Hw7SWYHxz.vIm3DmX02bdNbPfsn_Q_erlI0e_GRl7 dBOGkqdVyVl_V.03yfYuwFroJiCJNEy0ASPtSbH8IyuyuiCbs4GWNjwu7pLvLCbQFwiU_Nj2WT1u Sv27nR1aSUXAnQwp3wD8tDi0jY9YTNvXgZyOsDkIpXlnWU_kp6QK4veJQKLuYxwRjz5JbgBL.TAn jj558CY.j6OqeXjFftShqtoeLvekPaK6SVftgTzpFScUAYXzyPKKjIH9TAy9xjwULk88FBcpHX.D puEVzBs28_yi8EWp4hM.pVyaW3A-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.ir2.yahoo.com with HTTP; Wed, 8 Feb 2023 10:37:20 +0000 Date: Wed, 8 Feb 2023 10:37:19 +0000 (UTC) From: Antoine Besnier To: "pgsql-jdbc@postgresql.org" Message-ID: <1612831686.2850460.1675852639448@mail.yahoo.com> In-Reply-To: References: Subject: Re: Regarding UUID MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2850459_1455337520.1675852639446" X-Mailer: WebService/1.1.21161 YMailNorrin Content-Length: 4288 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2850459_1455337520.1675852639446 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You'd need to convert your string to a valid UUID first.See https://stacko= verflow.com/questions/29059530/is-there-any-way-to-generate-the-same-uuid-f= rom-a-string for ideas What do you mean by "customised UUID"? UUID format is standardized by defin= ition. But that looks like a X-Y problem. If you already have an ID, why generate = a new one? Antoine Le mercredi 8 f=C3=A9vrier 2023 =C3=A0 11:21:24 UTC+1, Laurenz Albe a =C3=A9crit : =20 =20 On Wed, 2023-02-08 at 15:25 +0530, lekha Tripathi wrote: > I am having a table with a column type UUID and to insert this column val= ue i > am having value like "1344443456" in text datatype and i want to insert t= his value as UUID . > While trying to insert this value getting error for UUID , > So is any way to convert my given value into customised UUID? > Let me=C2=A0know if any way to do so. That does not look like a valid UUID at all.=C2=A0 I have no idea how that = could be converted to an UUID, same as I don't know how "hello" should be converted = to a timestamp.=C2=A0 Perhaps you have some more information? Yours, Laurenz Albe =20 ------=_Part_2850459_1455337520.1675852639446 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You'd need to convert your s= tring to a valid UUID first.

What= do you mean by "customised UUID"? UUID format is standardized by definitio= n.

But that looks like a X-Y problem. If you already = have an ID, why generate a new one?

Antoine



=20
=20
Le mercredi 8 f=C3=A9vrier 2023 =C3=A0 11:21:24 UTC+1, = Laurenz Albe <laurenz.albe@cybertec.at> a =C3=A9crit :


On Wed, 2023-02-08 at 15:25 +0530, le= kha Tripathi wrote:

> I am having a table with a column type= UUID and to insert this column value i
> am having va= lue like "1344443456" in text datatype and i want to insert this value as U= UID .
> While trying to insert this value getting erro= r for UUID ,
> So is any way to convert my given value= into customised UUID?
> Let me know if any way t= o do so.


That does not look like= a valid UUID at all.  I have no idea how that could be
converted to an UUID, same as I don't know how "hello" should be conver= ted to
a timestamp.  Perhaps you have some more info= rmation?

Yours,
Laur= enz Albe



------=_Part_2850459_1455337520.1675852639446--