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 1ns3BD-0002L0-GE for pgsql-bugs@arkaria.postgresql.org; Fri, 20 May 2022 14:00:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ns3BC-0000Wi-67 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 May 2022 14:00:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns2SG-0008AV-0p for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 13:14:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns2SC-0002l7-Vx for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 13:14:07 +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=30hLbpIJko7Vo/y926K5EUsJSc4Z+JlDmez2jm6neho=; b=kyG0A3qz9cxemSMJSFDLKwiIP1 7LpKGF1Fq9ITbTznG9pynyw7k/xzrJYyBLRugkAM2IFrgqfLYew8H2Dm5A4WebEppgcQp0H6TKmVP d/4L4ml3KwaCoGQdchMAZsMTk1MYYIflII7dS1/XZmeBOsOJllbl1VrZX4dP37ddf0q5sYUZx8tUl YtzRFC55wLkPpMlonhU1I6QRxuh0NRY+NxeNS2/qR8uWQ4OIO5DLICRs/3YAF/lCXWX0YUjWpheuI zWpNnbptPXq1nDqXfS004mZFpR+ytuUUbowJGjY4wjIJtfqZVEIUFZITkElmStOoVXAKjecH2lQaO aSa2x4AA==; 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 1ns2SC-0006Yk-B4 for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 13:14:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ns2SA-0016E6-2Z for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 13:14:02 +0000 Content-Type: multipart/mixed; boundary="===============2514008904984488595==" MIME-Version: 1.0 Subject: BUG #17490: unconsistency between TRUNCATE RESTART IDENTITY and setval() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sebastien@lardiere.net Reply-To: sebastien@lardiere.net, pgsql-bugs@lists.postgresql.org Date: Fri, 20 May 2022 13:13:36 +0000 Message-ID: <17490-fd63590229a42d2e@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2514008904984488595== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ5MApMb2dnZWQgYnk6ICAgICAgICAgIFPDqWJhc3RpZW4gTGFyZGnD qHJlCkVtYWlsIGFkZHJlc3M6ICAgICAgc2ViYXN0aWVuQGxhcmRpZXJlLm5ldApQb3N0Z3JlU1FM IHZlcnNpb246IDE0LjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4KRGVzY3JpcHRpb246ICAg ICAgICAKCkkndmUgZm91bmQgYW4gdW5jb25zaXN0ZW5jeSBiZXR3ZWVuIFRSVU5DQVRFIFJFU1RB UlQgSURFTlRJVFkgYW5kIHNldHZhbCgpCmZ1bmN0aW9uLiANCg0KRmlyc3QsIGxldCdzIHF1b3Rl IHRoZSBkb2N1bWVudGF0aW9uLCBhYm91dCBUUlVOQ0FURTogDQoNCj4gV2hlbiBSRVNUQVJUIElE RU5USVRZIGlzIHNwZWNpZmllZCwgdGhlIGltcGxpZWQgQUxURVIgU0VRVUVOQ0UgUkVTVEFSVApv cGVyYXRpb25zIGFyZSBhbHNvIGRvbmUgdHJhbnNhY3Rpb25hbGx5Ow0KDQphbmQgYWJvdXQgQUxU RVIgU0VRVUVOQ0UgUkVTVEFSVDoNCg0KPiBUaGlzIGlzIHNpbWlsYXIgdG8gY2FsbGluZyB0aGUg c2V0dmFsIGZ1bmN0aW9uIHdpdGggaXNfY2FsbGVkID0gZmFsc2UNCg0KQWN0dWFsbHksIGJvdGgg YXJlIG5vdCBlcXVpdmFsZW50IGluIHRlcm0gb2YgZ3JhbnRzOiByb2xlIGhhcyB0byBiZSBvd25l ciBvZgp0aGUgc2VxdWVuY2UgdG8gcnVuIEFMVEVSIFNFUVVFTkNFIFJFU1RBUlQsIGJ1dCBvbmx5 IG5lZWRzIHRoZSBncmFudCBVUERBVEUKdG8gcnVuIHNldHZhbCgpIG9uIHRoZSBzZXF1ZW5jZS4g DQoNClNvLCB3aGVuIHJvbGUgaXMgbm90IHRoZSBvd25lciwgaGUgY2FuIFRSVU5DQVRFIGFuZCBz ZXR2YWwoKSB3aXRoIHRoZQpncmFudHMsIGJ1dCBjYW4ndCBUUlVOQ0FURSBSRVNUQVJUIElERU5U SVRZLCBiZWNhdXNlIG9mIEFMVEVSIFNFUVVFTkNFClJFU1RBUlQuIA0KDQpJdCdzIHByb2JhYmx5 IG5vdCBhIGJ1ZywgYnV0IG1heWJlIEFMVEVSIFNFUVVFTkNFIFJFU1RBUlQgc2hvdWxkIGJlIHJ1 biB3aXRoCnRoZSBzYW1lIGdyYW50IHRoYW4gc2V0dmFsKCkuDQoNCkhlcmUncyBhIHNpbXBsZSB1 c2VjYXNlIDogDQoNCg0KXGMgcG9zdGdyZXMgcG9zdGdyZXMNCkRST1AgREFUQUJBU0UgSUYgRVhJ U1RTIHJlc3RhcnRfc2VxX2ZhaWxlZDsNCg0KRFJPUCBST0xFIElGIEVYSVNUUyBkdW1ib3duZXI7 DQpEUk9QIFJPTEUgSUYgRVhJU1RTIGR1bWJ1c2VyOw0KDQpDUkVBVEUgUk9MRSBkdW1ib3duZXIg TE9HSU47DQpDUkVBVEUgUk9MRSBkdW1idXNlciBMT0dJTjsNCg0KDQpDUkVBVEUgREFUQUJBU0Ug cmVzdGFydF9zZXFfZmFpbGVkIE9XTkVSIGR1bWJvd25lciA7DQoNClxjIHJlc3RhcnRfc2VxX2Zh aWxlZCBkdW1ib3duZXINCg0KQ1JFQVRFIFRBQkxFIHRlc3RfdGFibGUgKA0KICBpZCBiaWdpbnQg R0VORVJBVEVEIEFMV0FZUyBBUyBJREVOVElUWQ0KICAsIHZhbCBpbnRlZ2VyDQopOw0KDQpHUkFO VCBVUERBVEUgLCBTRUxFQ1QgLCBVU0FHRQ0KICBPTiBTRVFVRU5DRSB0ZXN0X3RhYmxlX2lkX3Nl cQ0KICBUTyBkdW1idXNlcjsNCg0KR1JBTlQgVFJVTkNBVEUNCiAgT04gVEFCTEUgdGVzdF90YWJs ZQ0KICBUTyBkdW1idXNlcjsNCg0KSU5TRVJUIElOVE8gdGVzdF90YWJsZSAodmFsKQ0KICBTRUxF Q1QgZy52DQogIEZST00gZ2VuZXJhdGVfc2VyaWVzKDAgLCAxMDApIEFTIGcodik7DQoNClxjIHJl c3RhcnRfc2VxX2ZhaWxlZCBkdW1idXNlcg0KDQpUUlVOQ0FURSB0ZXN0X3RhYmxlIFJFU1RBUlQg SURFTlRJVFk7DQotLSBFUlJPUjogIG11c3QgYmUgb3duZXIgb2Ygc2VxdWVuY2UgdGVzdF90YWJs ZV9pZF9zZXENCg0KQUxURVIgU0VRVUVOQ0UgdGVzdF90YWJsZV9pZF9zZXEgUkVTVEFSVCBXSVRI IDE7DQotLSBFUlJPUjogIG11c3QgYmUgb3duZXIgb2Ygc2VxdWVuY2UgdGVzdF90YWJsZV9pZF9z ZXENCg0KVFJVTkNBVEUgdGVzdF90YWJsZTsNCi0tIHdvcmtzDQoNClNFTEVDVCBzZXR2YWwoJ3Rl c3RfdGFibGVfaWRfc2VxJzo6cmVnY2xhc3MsMSxmYWxzZSk7DQotLSB3b3Jrcw0KDQpccQoK --===============2514008904984488595==--