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 1phAEK-0003w6-WE for pgsql-general@arkaria.postgresql.org; Tue, 28 Mar 2023 14:23:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phAEJ-0006hB-TW for pgsql-general@arkaria.postgresql.org; Tue, 28 Mar 2023 14:23:19 +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 1phAEJ-0006dg-Bu for pgsql-general@lists.postgresql.org; Tue, 28 Mar 2023 14:23:19 +0000 Received: from mx0c-001a4c01.pphosted.com ([67.231.158.153]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phAEG-0007ME-EX for pgsql-general@lists.postgresql.org; Tue, 28 Mar 2023 14:23:18 +0000 Received: from pps.filterd (m0210019.ppops.net [127.0.0.1]) by mx0c-001a4c01.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 32S72IBM003217; Tue, 28 Mar 2023 10:23:10 -0400 Received: from eur04-he1-obe.outbound.protection.outlook.com (mail-he1eur04lp2054.outbound.protection.outlook.com [104.47.13.54]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 3phvwq6bq7-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 28 Mar 2023 10:23:10 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=T3cJKeRHS9+kLJSJUMSPBYBe5vGzz6abhDarIWI8SKDQhM3jO5N5kxEp7Xd22EsCs6drtOH3TBm4D/xBQclgsjNKQsOl84sm7iRunDt2srFIzBjNf4dgesVxRayKXdfmtx3OI7kareTNEkZxX1iw+OEr0uDFNANO3JRwuDKH1liGjNEEVH7DMDqKiiLSSpMuG807rkB3eaAkNenvLDcgAj+UQ1WpGyF9UCiEEpmRu5QLNxUZ/s75/I3rLkNyeoZhfjy/vAx7aTQSR2a4tkOl4WcBrUIF61Z/4fGxOjG2EQXDGrDhtzq76cDVCN06lGIqnPSqlP10pNArTqbcv+qWOw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=6D07/GWAuArkxdcnTaOy06qEMgrN4rA3zl6Kyslb0yg=; b=UsmX6dvcObm3qLyR7ZXCuOMne0SVUNjEVTW88QAoL3bOB7Uw5V+3RW3wbZwnFcNx0nyo01yms7hVPGXh1D2ELLAkyap/YLP9vLtQhLCecrZ4HDEAMyAg7Rx8LTdiP5XE7jLdMhCTN37i01+P9+G6HolB03oQtBuStv7cczxf41kmEf3RpuVRqXK6ds4V6WeWV5blpTFlDcuEVd1sNegFno26k+uV1cJg4q1bUkO0VkbRUGCmH1ZbIpQ/NUvoYLi5oCVT5ueEFBOShbxeLfbim0LsSijGfUeMTnjI7H3lzbxjRLZuUJvIUdvN/HDfi94TW8i598RSS6fG0rW69y8YOw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=4js.com; dmarc=pass action=none header.from=4js.com; dkim=pass header.d=4js.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ourvolaris.onmicrosoft.com; s=selector2-ourvolaris-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=6D07/GWAuArkxdcnTaOy06qEMgrN4rA3zl6Kyslb0yg=; b=g9ZY7RLug8tp4TjtGPnnT3c6su6KcV4f3eeKGFl5238mDkTKB6s43LQwPWnUe4yU0rDi6PQdoIHnXkxxq50NKg6smIMpB5sNegvt+MHsMIb+lW8zpEbrjoOQjj4ovibbhy2sjIa7ttXmZP3svV7NgGEHBOS1KXBmzDcLDpwqcvg= Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by AM0P191MB0627.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:15d::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6222.33; Tue, 28 Mar 2023 14:23:06 +0000 Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::28e8:7564:6d5c:2579]) by DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::28e8:7564:6d5c:2579%6]) with mapi id 15.20.6222.031; Tue, 28 Mar 2023 14:23:06 +0000 From: Sebastien Flaesch To: Christophe Pettus CC: Geoff Winkless , pgsql-general Subject: Re: Using CTID system column as a "temporary" primary key Thread-Topic: Using CTID system column as a "temporary" primary key Thread-Index: AQHZYVZ01wVqNWW64Uy2W8xqK9Rs7a8P+z+AgAAEOkGAACKEgIAAHN4z Date: Tue, 28 Mar 2023 14:23:06 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DBAP191MB1289:EE_|AM0P191MB0627:EE_ x-ms-office365-filtering-correlation-id: c9c73d39-99e6-4c3a-24b0-08db2f97f2fe x-volarisppoutbound: true x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ZIb/sJU0L0gLArJVEcg0RVVTFwTUYX+BaCO930CHuqWofjwQbJ5KEV9MOK47IJgOmK7c2Tj9BPRt7H2N3T9AoMDD/HybhMffcUt5bHCPzO69Df4CSTa45+Uwde150z3tg4GcLNE61e59HstuLvTxr7d0McIdoWO3a1fCxH2uzF4ARaq9AJ4FkcGmj7LS38mmqtao3GTVeC3BwdzUX6kHIiw0P7qZf8196KVZDeeKPEt2l5HegUDFYxO8hyWyzY60b+V1jzD9+cDYgNC069ALxYIWMha5iyA2wBG6AEM79OOs+J9ob1eiofjQoyei7/ojW/20damx23nCwU0XgmYye+0jXZbZAv2tvXhza+XGouQB4cnDUigei22k+UDKKW+Zc4OTmSRskCsMY802NNewUpPgcCVDWIy9U31PKBhSc4Ql4uq48zewSrA1KKw+7hCnFl8IWXHuWOfBgw8eQsMIKokyW8lzxVe3zptmQdL0O7+wFr/IzWBHvW0sANu6TqTo6Xi9wRGKhFRXRMSydY89C6AtI6YrnheFmwL47w+ST5wXcE1OQ8xIZjchBOUmep7IfMK+Pj3fT0J2QYysb5DDrSgITKx/f6ru24yIU4ZjlCyxNsHIjSKps9YwR98tIYfH x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAP191MB1289.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230028)(4636009)(346002)(396003)(39860400002)(366004)(376002)(136003)(451199021)(66446008)(2906002)(71200400001)(44832011)(4744005)(38100700002)(7696005)(478600001)(86362001)(38070700005)(55016003)(54906003)(316002)(91956017)(5660300002)(66556008)(64756008)(8676002)(4326008)(52536014)(66476007)(76116006)(6916009)(122000001)(66946007)(8936002)(186003)(6506007)(41300700001)(53546011)(9686003)(26005)(33656002)(19627405001)(83380400001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?oPfk8p+glzsTiTLSj4k2PrhM8KesJCbVNA1IdvbBdNJku7yQXl+snjajbqZB?= =?us-ascii?Q?6z9s1hVq3+lh2FWsGrvqTRyETcxALKKCByajlQA31zarDBjRGsFAIpgNBtJY?= =?us-ascii?Q?1PUrXha+mooH8joCFCcu0rTIRF1UF1cGVTBCobr3gXTa8TMeRbu9vxoI6Ke3?= =?us-ascii?Q?AAAwsYpFvcBUTLGNVZ9WbEoUqEUoYPiAsFOR/pLjMS/MUgH8A4PNEQUNbnRX?= =?us-ascii?Q?0LTrAsKcVmkgOuZLE/2l+Abs/V612P3AQwaIBwMXVyV6CcjXiotxv00fBAMu?= =?us-ascii?Q?w/35Yh4mwtPIh7nmyqk/zMWjITxFmzwUc2dNOjAsNYMem1JV1AmQKvfKafMc?= =?us-ascii?Q?nLiuKUhOxc30f4gruTxvHOANR8ciXqbvy9ZwaPq73e6k9E4pQoBE0QgJrSbo?= =?us-ascii?Q?CqGZfPcGs3joPK2qeN4M2x65nxPwei7tdMjopcqxQZ53U25y5ygpgoZfUqW6?= =?us-ascii?Q?rxMZ4QctgkjKI43KqgudlnK8zdLJ6Hjtb+cGsyRgbU99J+1rQmfVQvje6Skr?= =?us-ascii?Q?hVZrXU5rnaG6fS3bB7cRzWnGdHSKZXAa+cW3O8UAV/SqGgvg5ENZIx4P5Iua?= =?us-ascii?Q?ZIEDW33cjWDw/qFFPsK1LiSOkaf8ZfAOftGVgz8B/1Ognrp9zB+CHZ4VQnZ7?= =?us-ascii?Q?YSBxWWseAHFz1LReSgPWkLfdxoNzH+FuPRB+CqZUSMyw7LW4ZWW991DvJcfw?= =?us-ascii?Q?xzNu+oF8WPZVEP0Rkb1i0xqpmVbamyDacQ3gqU86mqJmy1kITfbLrHbXuh6U?= =?us-ascii?Q?z3GggT5zBgdiW1ER0DuilAm3mposcREZSNZ78hokcZCMqUdzRa2bfJuvM1RE?= =?us-ascii?Q?qoJ+HuPZT8rnIVXStUCVlCtVCo8yADyrb5GjNtp4Kj6K+jmHQwz7nDjyFf3H?= =?us-ascii?Q?2Xt/jI30BF83NZSmXgYhDLRUBTDQznT1zjOmIMcvZM2f6i/rjFytQhdD8wRR?= =?us-ascii?Q?UpYZhNYeIigzbE89dqjfjzm4ak1p7imrBVFaHLJHUfmB1cPc/j3nRGX71B6J?= =?us-ascii?Q?LdQkSFXq2Pj9pSzF/b0mt9hmNIVCV8Ku5gtwuqASsN/rz5tu6iyJqPP8ZUD0?= =?us-ascii?Q?g4Pt44M7HpV8IpNetCgr5MXfT86rITjbUgOSOtcqKR2GlG/ujuGLVbCNLIUC?= =?us-ascii?Q?ET6t2SOmgjqv2DLmfIYYoFbjm8oJA2+w7BGS0G+sriTOXwYJbMRJg2hOXmCw?= =?us-ascii?Q?sSZ73q+aN0fTh/6yKd1GoGePfgTwbfTY/ki+bxXm7Ct+KUVXw2E3PlzgSMPL?= =?us-ascii?Q?rp3vuS/p1QUSgZfB94z3vXFfoBd5zQTizmYFIUhADM0+C3RaLKpbzp9f5NOA?= =?us-ascii?Q?0AdPLwGIhygwmm1AGrn451pXSFatBWR+vqBi/jonT/RyfrZ0aPYNxtURoP8l?= =?us-ascii?Q?3mXoVdSzXUbzH7gujYG1/p7nXKKElzYfLWAJo1gRcft+BEhtlgyuKB7s00F3?= =?us-ascii?Q?KDaFyuB/Xn68RYqEYSP/PTCp564ObzixRq4fDf1s1zh+GsfALuNrBgiA3zh+?= =?us-ascii?Q?UNsQjXhkpgalCv35im3mI7XKsXvb/LELR/plScna6uxa5c81XGgVzX6gvddy?= =?us-ascii?Q?QoUPpoUcdXLdXLLnwK3EtccVwqWdTi7z9k9OiMSW?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB128940FF558474BC6DA80CB7B0889DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 0onVwtRmQ9gzVwIs6DFCdz1B9KPdHET9qoLGzMZ1bzofPDZKKcMs8Qx10qE/P54EaTpBtkpU7/DYKHUelFSzlatrL7xv9sfoBsSN//cfxwW79P25dzGoBqk1uVZmmEK0lhdOkkOFwCIDplN16RygT0J3Xss9HOGyfSnqXGORJ7zyW2ibsEllx1rCd6z3nEBxd3Scb2ORTkHIE4yN9q475ognTpO8shCQHUMeSq+o6PxG2IXi1DURYncz6X3iZfsfsVdU94+kRVPYqiOhotSR7z8fup4otAqB5+4vnf6NfTcOtomrWG2DqJEc4W5oMmd5FO4uIgH4fJhnkjdl9OuYTotGJ25rUDcQyclqeO+qJYPaeWa+JAsUI6njURyw+WZLzx0X5vRBP3tmgy0xCNB3NGsNvrgRAz3ce5LByIkJYozqniz8xxH50lAwZfQT+v+6SXZi6GF0G2X5ijK3Nr4qKr6v0KilKk2mIa3C1B1Hrg8k92jfjlEdb5ale7Qs+sGUAoPae1LgnXj4lIZ+iKAKC2TX3U+kiLMrUVHC90yxHsaaPNs7jtCsz9PpKOmcckVjjUeUyFKV8T1Ro0WzMW3wjpzWB+0RwNML1Y5ry9vqRiGeN32IZBof+70kiwrxUI0mtDoOD6Bm1h5upHC2i+CjHubQI5cfuAKwj67z8iZC7H2bA/fFd5PXZs/NoRBp7LjKLTILfzizPotOXSSdd7BUKIEncoBNdG7nEdtYC1dl8yQ8smAKNhSFkvX1kOjvYdK8fhkI5nEEAmhaMp2eETlk8NTiSgTKtyKn5EXeW9ClE1OXL4lJ5GOCJAg5Z45+sgekIN0N20r7j/8ttHUZa10ancEkCyVD8hJr1BNfu2J7M9dJ2ZbrIsPSrQ4e1Uo1l+uB X-OriginatorOrg: 4js.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAP191MB1289.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: c9c73d39-99e6-4c3a-24b0-08db2f97f2fe X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Mar 2023 14:23:06.6183 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75c696ec-5bfb-4892-9a0c-9187a9061cd6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: uNFrdk9KXlsD1VhS9LbutbXIqR0+wIbqomSHMzx+IoK2L3csgsaZBxRIdqsdPIxaDl0xRTd2QAJWkbWB9d9GE5rrOC6c1wIE3LwR/Cpekik= X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P191MB0627 X-Proofpoint-ORIG-GUID: H5JmDwqi3MQHMxdu3vrF_GVkdqAyfsjB X-Proofpoint-GUID: H5JmDwqi3MQHMxdu3vrF_GVkdqAyfsjB X-ProofpointHeader: Yes X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 impostorscore=0 mlxscore=0 clxscore=1011 mlxlogscore=999 spamscore=0 lowpriorityscore=0 malwarescore=0 priorityscore=1501 phishscore=0 adultscore=0 suspectscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2303200000 definitions=main-2303280113 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB128940FF558474BC6DA80CB7B0889DBAP191MB1289EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable CAST seems to do the job so that's a good solution here. Seb ________________________________ From: Christophe Pettus Sent: Tuesday, March 28, 2023 2:39 PM To: Sebastien Flaesch Cc: Geoff Winkless ; pgsql-general Subject: Re: Using CTID system column as a "temporary" primary key EXTERNAL: Do not click links or open attachments if you do not recognize th= e sender. > On Mar 28, 2023, at 03:39, Sebastien Flaesch = wrote: > Do I have to cast() ? Yes: select * from t where ctid=3D'(0,1)'::tid; The string representation can be up to 17 characters: 10 for the page numbe= r, 4 for the tuple number, and three for the delimiters. Remember that updating a row changes its CTID. --_000_DBAP191MB128940FF558474BC6DA80CB7B0889DBAP191MB1289EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
CAST seems to do the job so that's a good solution here.

Seb

From: Christophe Pettus <= ;xof@thebuild.com>
Sent: Tuesday, March 28, 2023 2:39 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>
Cc: Geoff Winkless <pgsqladmin@geoff.dj>; pgsql-general <pg= sql-general@lists.postgresql.org>
Subject: Re: Using CTID system column as a "temporary" pri= mary key
 
EXTERNAL: Do not click links or open attachments i= f you do not recognize the sender.

> On Mar 28, 2023, at 03:39, Sebastien Flaesch <sebastien.flaesch@4js= .com> wrote:
> Do I have to cast() ?

Yes:

        select * from t where ctid=3D'(0= ,1)'::tid;

The string representation can be up to 17 characters: 10 for the page numbe= r, 4 for the tuple number, and three for the delimiters.

Remember that updating a row changes its CTID.
--_000_DBAP191MB128940FF558474BC6DA80CB7B0889DBAP191MB1289EURP_--