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 1kYckm-0003NW-Lt for pgsql-bugs@arkaria.postgresql.org; Fri, 30 Oct 2020 22:20:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kYckl-0007vv-BA for pgsql-bugs@arkaria.postgresql.org; Fri, 30 Oct 2020 22:20:11 +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 1kYcGg-0002hG-SS for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 21:49:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYcGe-0004wy-Rh for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 21:49:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=gF5RMcgyNSKyGXzC53umNw0jiIcmw39Tsa9VwmHbaHo=; b=GFj+VeTGY+jc879tUMRa5yN1s8 fqmbDbl+03HBHX0m6G+aaO/KbzqHivtQbqMH4ejRhLtpQlLvrkhEs2GDX1zfoQn1OFAQrsAjxSpyj ochTvNkffGGPMEpe/E1ojMhQJuFWn81aCwUZR+UjUUwrRZuDdgLk7zgaC6zqZZcM8vUaou0pkBDa7 mClaF5SpF1mw0j+dpWm6obV5SUuoqFD9OiB+mH0nfB1bdEkTJaoGFOEKxQNGgbNQJQZFclC/eLJ99 dHIZxStYSlGrpfqfYiTRhO1q+RtM3exPJYqK9eHpHx0MhMRnzoo2FawpO/jERTFy8f6nsErwkshsC 9Km4Hxsw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYcGd-0002ED-Cv for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 21:49:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kYcGc-0000Uc-59 for pgsql-bugs@lists.postgresql.org; Fri, 30 Oct 2020 21:49:02 +0000 Content-Type: multipart/mixed; boundary="===============4611645237338965667==" MIME-Version: 1.0 Subject: BUG #16693: Weird behaviour of function uuid_generate_v5() when used in a trigger To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: vtap01@gmail.com Reply-To: vtap01@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 30 Oct 2020 21:48:34 +0000 Message-ID: <16693-5e7a7034d8eace85@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4611645237338965667== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjY5MwpMb2dnZWQgYnk6ICAgICAgICAgIFZpbmNlbnQgVGFwCkVtYWls IGFkZHJlc3M6ICAgICAgdnRhcDAxQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjQK T3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwICg2NCBiaXRzKQpEZXNjcmlwdGlvbjogICAg ICAgIAoKSGksDQoNCkkgd2FudCB0byBnZW5lcmF0ZSBzdGFibGUgVVVJRHMgb25seSBkZXBlbmRp bmcgb24gdGhlIGNvbnRlbnRzIG9mIGEgZmllbGQuCkZ1bmN0aW9uIHV1aWRfZ2VuZXJhdGVfdjUg ZnJvbSBleHRlbnNpb24gdXVpZC1vc3NwIGxvb2tlZCBwZXJmZWN0LiBJIGNoZWNrZWQKdGhhdCB0 aGUgZnVuY3Rpb24gZ2VuZXJhdGVzIGFuIGlkZW50aWNhbCBVVUlEIGV2ZW4gb24gMiBkaWZmZXJl bnQgZGF0YWJhc2VzCjoNCg0KU0VMRUNUIHV1aWRfZ2VuZXJhdGVfdjUgKHV1aWRfbmlsICgpLCBM T1dFUihUUklNKCdBTElNRU5UQVRJT04nKSkpOw0KYWx3YXlzIGdlbmVyYXRlcw0KZmYyNzI0MGYt N2Y2Yy01MTI3LWE4YjEtZTAyODlkMTRkODk1DQoNCkJ1dCB3aGVuIEkgaW5jbHVkZSBpdCBpbiBh IHRyaWdnZXIsIHJlc3VsdHMgdmFyeSBlYWNoIHRpbWUuIE15IHRyaWdnZXIKY29udGFpbnMgdGhl IGZvbGxvd2luZyANCg0KLS0gR8OpbsOpcmF0aW9uIG5vdXZlbCBpZGVudGlmaWFudA0KICAgIElG IChUR19PUCA9ICdJTlNFUlQnKSBUSEVODQogICAgICAgIElGIChORVcuYW5hbHl0aXF1ZV91dWlk IElTIE5VTEwpIFRIRU4NCiAgICAgICAgICAgIE5FVy5hbmFseXRpcXVlX3V1aWQgPSB1dWlkX2dl bmVyYXRlX3Y1KHV1aWRfbmlsKCksCkxPV0VSKFRSSU0oZ3JvdXBlKSkpOw0KICAgICAgICBFTkQg SUY7DQogICAgRU5EIElGOw0KLS0gR8OpbsOpcmF0aW9uIGhvcm9kYXRhZ2VzDQogICAgSUYgKFRH X09QIElOICgnSU5TRVJUJywgJ1VQREFURScpKSBUSEVODQogICAgICAgIE5FVy50cyA9IG5vdygp Ow0KLS0gTWVzc2FnZSBkYW5zIGxlIGZpY2hpZXIgZGUgbG9nDQogICAgICAgIFJBSVNFIE5PVElD RSAnKiAqICogVHJpZ2dlciAlIGFwcGVsw6kgJSAlLiBhbmFseXRpcXVlX3V1aWQgPSBbJV0gKiAq CionLCBUR19OQU1FLCBUR19XSEVOLCBUR19PUCwgTkVXLmFuYWx5dGlxdWVfdXVpZDsNCiAgICAg ICAgUkVUVVJOIE5FVzsNCiAgICBFTkQgSUY7DQoNClVzaW5nIHRoZSBsb2csIHRoZSBub3RpY2Ug aXMgYXZhaWxhYmxlLCBzbyBJJ20gc3VyZSB0aGF0IHRoZSB0cmlnZ2VyIGlzCmZpcmVkLiBCdXQg aW5zZXJ0aW5nIHR3aWNlIHRoZSBzYW1lIHZhbHVlIGdlbmVyYXRlcyAyIGRpaWZmZXJlbnQgVVVJ RHMgOg0KRXhhbXBsZSA6DQoNClNFTEVDVCBncm91cGUsIGFuYWx5dGlxdWVfdXVpZCwgdXVpZF9n ZW5lcmF0ZV92NSAodXVpZF9uaWwgKCksCkxPV0VSKFRSSU0oZ3JvdXBlKSkpLCB0cyBGUk9NIGFu YWx5dGlxdWUgV0hFUkUgZ3JvdXBlID0gJ0FMSU1FTlRBVElPTic7DQoNCkFMSU1FTlRBVElPTglm MDk3NGI2Mi01NDIyLWM0NGQtMDc2Ni05MmE3NjY5YTY2NzgJZmYyNzI0MGYtN2Y2Yy01MTI3LWE4 YjEtZTAyODlkMTRkODk1CTIwMjAtMTAtMzAKMjI6MDg6NDAgKzAxMDANCkFMSU1FTlRBVElPTgk0 MGU3YThlNy04NjVlLTQwN2YtYjFiMS1lOWE3MzMxZTUxYjMJZmYyNzI0MGYtN2Y2Yy01MTI3LWE4 YjEtZTAyODlkMTRkODk1CTIwMjAtMTAtMzAKMjI6MDg6NDYgKzAxMDANCg0KRGlkIEkgbWlzcyBz b21ldGhpbmcgb3IgaXMgaXQgYSBidWcgPw0KDQpUaGFua3MgYW5kIHJlZ2FyZHMuDQoNClZpbmNl bnQgVGFwDQpGcmFuY2UKCg== --===============4611645237338965667==--