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 1oDNmv-0000oD-Qk for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Jul 2022 10:15:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oDNmu-0001cP-0X for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Jul 2022 10:15:40 +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 1oDNU2-0004OS-BZ for pgsql-bugs@lists.postgresql.org; Mon, 18 Jul 2022 09:56:10 +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 1oDNTy-0001x4-5q for pgsql-bugs@lists.postgresql.org; Mon, 18 Jul 2022 09:56:09 +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=ZGAKR3RW3UYDK/UO6q9scVukPqxM0jTyfLJ9kGevYSI=; b=wDpU7B4J/sam/gXRbSWkmFYmH5 Fzi53JITxUKCCXDuVATTtXxYwuGdaHJrpy0y/E0y+MKpWCVlPfHJYr9P/AGobDCjhVLu0hQ0bJYb7 ppMzykWwPLntVma2HyB1ccVfgpxqA+Wscdx9dVKBIWgAwUsyA/kWwL+ODm+tiKHaZ3Va38cbSR8vp 7xYu9RgVO8TdzqGW1PWOe5qBwQKkgs3RzkvPHck9r4XFpMfwoBdW5huQcYPoR60Bh5iXJmYWkMiSV kWZbYkEWZottYTbzfilLRmD8V8QcRVvs1ipRaIQ7QHFPGrIsF3XCsDGloO3WXdl81XGERoclBQtik BEEkfhuA==; 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 1oDNTw-00028G-N1 for pgsql-bugs@lists.postgresql.org; Mon, 18 Jul 2022 09:56: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 1oDNTu-002l13-3z for pgsql-bugs@lists.postgresql.org; Mon, 18 Jul 2022 09:56:02 +0000 Content-Type: multipart/mixed; boundary="===============7626863456015138590==" MIME-Version: 1.0 Subject: BUG #17554: when i use rule on table which have serial column, the nextval exec twice. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: szittya314@gmail.com Reply-To: szittya314@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 18 Jul 2022 09:55:26 +0000 Message-ID: <17554-3a1ae834cdb577ac@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 --===============7626863456015138590== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU1NApMb2dnZWQgYnk6ICAgICAgICAgIFN6YWJvbGNzIEtsZW1lbnQK RW1haWwgYWRkcmVzczogICAgICBzeml0dHlhMzE0QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE0LjQKT3BlcmF0aW5nIHN5c3RlbTogICBSb2NreSBMaW51eCByZWxlYXNlIDguNSAoR3Jl ZW4gT2JzaWRpYW4pCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwNCihzb3JyeSBteSBwb29yIGVu Z2xpc2gpDQp0aGUgcHJvYmxlbSBpcyBpbiAxMC0xNCBwb3N0Z3Jlc3FsIHRvby4NCg0KdGhpcyBh IHNhbXBsZSB3aGF0IG1ha2UgZ2FwIGluIHNlcXVlbmNlOg0KY3JlYXRlIHRhYmxlIGFhIChpZCBz ZXJpYWwgcHJpbWFyeSBrZXksdHQgdGV4dCk7DQpjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBm aWthMShwMSBhYSkgcmV0dXJucyBib29sZWFuIGxhbmd1YWdlIHNxbCBhcw0KJGJvZHkkDQoJc2Vs ZWN0IChwMS5pZCk6OmJvb2xlYW47DQokYm9keSQ7DQpjcmVhdGUgb3IgcmVwbGFjZSBydWxlIGJp cmttYW4gYXMgb24gaW5zZXJ0IHRvIGFhIGRvIHNlbGVjdCBmaWthMShuZXcpOw0KDQppbnNlcnQg aW50byBhYSAodHQpIHZhbHVlcyAoJ3V1Jyk7DQpzZWxlY3QgKiBmcm9tIGFhIG9yZGVyIGJ5IGlk Ow0KDQood2hlbiBpbm5lciB0aGUgZnVuY3Rpb24gaXNudCByZWZlcmVuY2UgYSBuZXcgcmVjb3Jk LCB0aGVyZSBpc250IGdhcDoNCmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIGZpa2ExKHAxIGFh KSByZXR1cm5zIGJvb2xlYW4gbGFuZ3VhZ2Ugc3FsIGFzDQokYm9keSQgc2VsZWN0IHRydWU7CSRi b2R5JDsNCikNCg0KaW5uZXIgdGhlIGZ1bmN0aW9uIHRoZW4gcDEuaWQgaXMgYWx3YXlzIFgsIGJ1 dCBhZnRlciB0aGUgaW5zZXJ0IGluIHRoZSBuZXcKcmVjb3JkIGlzIFgtMTsNCg0KaSB0cnkgd2l0 aCBwbHBnc3FsIGZ1bmN0aW9uOg0KY3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24gZmlrYTEocDEg YWEpIHJldHVybnMgYm9vbGVhbiBsYW5ndWFnZSBwbHBnc3FsCmFzDQokYm9keSQNCiAgYmVnaW4N CiAgCXJhaXNlIG5vdGljZSAnaWQ6JScsIHAxLmlkOw0KCXJldHVybiB0cnVlOwktLUkgZGlkbnQg cmVmZXJlbmNlZCB0aGUgbmV3IHZhbHVlDQogIGVuZDsNCiRib2R5JDsNCg0KQmVzdCByZWdhcmRz DQpTemFib2xjcwoK --===============7626863456015138590==--