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 1kUnxs-0006yL-IQ for pgadmin-hackers@arkaria.postgresql.org; Tue, 20 Oct 2020 09:29:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kUnxr-0002qe-9a for pgadmin-hackers@arkaria.postgresql.org; Tue, 20 Oct 2020 09:29:55 +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 1kUnxq-0002oY-KJ for pgadmin-hackers@lists.postgresql.org; Tue, 20 Oct 2020 09:29:54 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kUnxm-0005ZU-EY for pgadmin-hackers@postgresql.org; Tue, 20 Oct 2020 09:29:52 +0000 Received: by mail-pl1-x62e.google.com with SMTP id t22so717142plr.9 for ; Tue, 20 Oct 2020 02:29:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=m7tg4jg8R9WbXBHTauSqi1kfQ8gTLc4bNTbS/J/L4Qc=; b=lWHIZpuJ8NYDsfwxC7Mps5Zoo6eDVFaAtpwVFYj1oPdy0/qwv7fg/0ukqRHxWI//Op +OFqS/PRiBuI/eLF7Ijfpe+1e0d73ktf3RuhV6HLM2zs9J+uvMFs3m+da72HMTcPsipE 8tg0S0AQlPQNsSfUgE2v/uvJ8CJmAluYWw2GP37wVHbfa3h/gZr4+Jiy/ww6O2h7pudN VrwZQYzxsa01cB5BmZBBgZCR/gG+P/tOgwobPkttJR1K1K5a42nP1m0AUPn9J4m2i1BJ KvGjVDJ4wqnsiflT/92nMVe1UvWnkTAosnUqXLv2bNxEZFL6rM5/xSS6CbU3mEct04sH vJmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=m7tg4jg8R9WbXBHTauSqi1kfQ8gTLc4bNTbS/J/L4Qc=; b=ZkTj2rMKUk9uV531umGVv2Vu6nVK4PPd7nUkhPg+LS3SbJGTXCuqHqq46cr1y/esVU 1EoRH3l1E2G0vOAJC+QFyjTQeYylC5Vobowm19eTjlPopdnqc27nBm/nNHcJnR2yF/Mh nhL082ABsnBAevVIHBOwD8AzvBowPJldgFsU9iqKTTfPYFyU/cN2WBwwN25Y4qY9o7xB /xGbIdck3KqO5RFjpzDFkm3FLtcrDnKqY1hsZkhUeGHRbleI9Dik9bUJjws4zGroHv27 9KnoZYXvHp7b2eafd9z/nj1Ls3i3ts50CRBSoIY0RLOxXJ6M5dwzBYwUVf6j5zGlKaCr vITA== X-Gm-Message-State: AOAM533eCc8wHTo4SJq73HIiGVvNjEzwPoQDQtk9Fab6KRrhKHgCo9hq cy3DP2PBf6DuRJXEfIACj45fPanl6N/C3j084Z12gH0Q8lpweOG+Igc7WueNed1COtpxieDL/ta h8WV4kMb6Mf/r7WI5WjM+QNDXqcCBw6XwK4mvj9f6j/wPbwM8M8AScXcuBcUrj+WPCHZWQxLdZE f3gFaLtjbPEI/+5FypGnk6opn9+rI4/8CtngHIf45Ubt8ubdnczw6d5G/V7IWvm68= X-Google-Smtp-Source: ABdhPJzWX3y3nsDXcKITAOzj0Jpo6XjpYSvGw1YTY8XZnR5PxGtHKGAI+GDvscMrYRUjs6k75QuUQtJIDGLGNSQf8tg= X-Received: by 2002:a17:90b:305:: with SMTP id ay5mr2033041pjb.129.1603186188872; Tue, 20 Oct 2020 02:29:48 -0700 (PDT) MIME-Version: 1.0 From: Pradip Parkale Date: Tue, 20 Oct 2020 14:59:37 +0530 Message-ID: Subject: [pgAdmin][RM4639]: Truncate Trigger option should enabled in properties sections if trigger is already created without each rows To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000004c2ee305b216df89" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000004c2ee305b216df89 Content-Type: multipart/alternative; boundary="0000000000004c2ee105b216df87" --0000000000004c2ee105b216df87 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Please find the attached for RM4639 and RM5779. For the trigger, most of the fields will be disabled in edit mode. -- Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --0000000000004c2ee105b216df87 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,
Please find the attached for RM4639 and RM= 5779. For the trigger, most of the fields will be disabled in edit mode.


--
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation=
--0000000000004c2ee105b216df87-- --0000000000004c2ee305b216df89 Content-Type: application/octet-stream; name="RM4639.patch" Content-Disposition: attachment; filename="RM4639.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kghrcqd70 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcyBiL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L3RhYmxlcy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcwppbmRleCA0ZDBmNGM5MzYuLjNk ZDY3MjljMyAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RyaWdnZXJzL3N0YXRpYy9qcy90cmlnZ2Vy LmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcwpAQCAtMjA5 LDYgKzIwOSw5IEBAIGRlZmluZSgncGdhZG1pbi5ub2RlLnRyaWdnZXInLCBbCiAgICAgICAgICAg ZGVwczogWydpc19jb25zdHJhaW50X3RyaWdnZXInXSwKICAgICAgICAgICBkaXNhYmxlZDogZnVu Y3Rpb24obSkgewogICAgICAgICAgICAgLy8gRGlzYWJsZWQgaWYgdGFibGUgaXMgYSBwYXJ0aXRp b25lZCB0YWJsZS4KKyAgICAgICAgICAgIGlmICghbS5pc05ldygpKQorICAgICAgICAgICAgICBy ZXR1cm4gdHJ1ZTsKKwogICAgICAgICAgICAgaWYgKF8uaGFzKG0sICdub2RlX2luZm8nKSAmJiBf LmhhcyhtLm5vZGVfaW5mbywgJ3RhYmxlJykgJiYKICAgICAgICAgICAgICAgXy5oYXMobS5ub2Rl X2luZm8udGFibGUsICdpc19wYXJ0aXRpb25lZCcpICYmCiAgICAgICAgICAgICAgICBtLm5vZGVf aW5mby50YWJsZS5pc19wYXJ0aXRpb25lZCAmJiBtLm5vZGVfaW5mby5zZXJ2ZXIudmVyc2lvbiA8 IDExMDAwMApAQCAtMzY3LDYgKzM3MCw4IEBAIGRlZmluZSgncGdhZG1pbi5ub2RlLnRyaWdnZXIn LCBbCiAgICAgICAgICAgfSwKICAgICAgICAgICBjb250cm9sOiAnc2VsZWN0MicsIHNlbGVjdDI6 IHsgYWxsb3dDbGVhcjogZmFsc2UsIHdpZHRoOiAnMTAwJScgfSwKICAgICAgICAgICBkaXNhYmxl ZDogZnVuY3Rpb24obSkgeworICAgICAgICAgICAgaWYgKCFtLmlzTmV3KCkpCisgICAgICAgICAg ICAgIHJldHVybiB0cnVlOwogICAgICAgICAgICAgLy8gSWYgY29udHJhaW50IHRyaWdnZXIgaXMg c2V0IHRvIFRydWUgdGhlbiBvbmx5IGVuYWJsZSBpdAogICAgICAgICAgICAgdmFyIGlzX2NvbnN0 cmFpbnRfdHJpZ2dlciA9IG0uZ2V0KCdpc19jb25zdHJhaW50X3RyaWdnZXInKTsKICAgICAgICAg ICAgIGlmKCFtLmluU2NoZW1hV2l0aE1vZGVsQ2hlY2suYXBwbHkodGhpcywgW21dKSkgewpAQCAt Mzk5LDcgKzQwNCw3IEBAIGRlZmluZSgncGdhZG1pbi5ub2RlLnRyaWdnZXInLCBbCiAgICAgICAg ICAgICBjb250cm9sc0NsYXNzTmFtZTogJ3BnYWRtaW4tY29udHJvbHMgcGctZWwtc20tNyBwZy1l bC0xMicsCiAgICAgICAgICAgICBkaXNhYmxlZDogZnVuY3Rpb24obSkgewogICAgICAgICAgICAg ICB2YXIgZXZuX2luc2VydCA9IG0uZ2V0KCdldm50X2luc2VydCcpOwotICAgICAgICAgICAgICBp ZiAoIV8uaXNVbmRlZmluZWQoZXZuX2luc2VydCkgJiYgbS5ub2RlX2luZm9bJ3NlcnZlciddWydz ZXJ2ZXJfdHlwZSddID09ICdwcGFzJykKKyAgICAgICAgICAgICAgaWYgKCFfLmlzVW5kZWZpbmVk KGV2bl9pbnNlcnQpICYmIG0ubm9kZV9pbmZvWydzZXJ2ZXInXVsnc2VydmVyX3R5cGUnXSA9PSAn cHBhcycgJiYgbS5pc05ldygpKQogICAgICAgICAgICAgICAgIHJldHVybiBmYWxzZTsKICAgICAg ICAgICAgICAgcmV0dXJuIG0uaW5TY2hlbWFXaXRoTW9kZWxDaGVjay5hcHBseSh0aGlzLCBbbV0p OwogICAgICAgICAgICAgfSwKQEAgLTQxMiw3ICs0MTcsNyBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9k ZS50cmlnZ2VyJywgWwogICAgICAgICAgICAgY29udHJvbHNDbGFzc05hbWU6ICdwZ2FkbWluLWNv bnRyb2xzIHBnLWVsLXNtLTcgcGctZWwtMTInLAogICAgICAgICAgICAgZGlzYWJsZWQ6IGZ1bmN0 aW9uKG0pIHsKICAgICAgICAgICAgICAgdmFyIGV2bl91cGRhdGUgPSBtLmdldCgnZXZudF91cGRh dGUnKTsKLSAgICAgICAgICAgICAgaWYgKCFfLmlzVW5kZWZpbmVkKGV2bl91cGRhdGUpICYmIG0u bm9kZV9pbmZvWydzZXJ2ZXInXVsnc2VydmVyX3R5cGUnXSA9PSAncHBhcycpCisgICAgICAgICAg ICAgIGlmICghXy5pc1VuZGVmaW5lZChldm5fdXBkYXRlKSAmJiBtLm5vZGVfaW5mb1snc2VydmVy J11bJ3NlcnZlcl90eXBlJ10gPT0gJ3BwYXMnICYmIG0uaXNOZXcoKSkKICAgICAgICAgICAgICAg ICByZXR1cm4gZmFsc2U7CiAgICAgICAgICAgICAgIHJldHVybiBtLmluU2NoZW1hV2l0aE1vZGVs Q2hlY2suYXBwbHkodGhpcywgW21dKTsKICAgICAgICAgICAgIH0sCkBAIC00MjUsMTMgKzQzMCwx MyBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS50cmlnZ2VyJywgWwogICAgICAgICAgICAgY29udHJv bHNDbGFzc05hbWU6ICdwZ2FkbWluLWNvbnRyb2xzIHBnLWVsLXNtLTcgcGctZWwtMTInLAogICAg ICAgICAgICAgZGlzYWJsZWQ6IGZ1bmN0aW9uKG0pIHsKICAgICAgICAgICAgICAgdmFyIGV2bl9k ZWxldGUgPSBtLmdldCgnZXZudF9kZWxldGUnKTsKLSAgICAgICAgICAgICAgaWYgKCFfLmlzVW5k ZWZpbmVkKGV2bl9kZWxldGUpICYmIG0ubm9kZV9pbmZvWydzZXJ2ZXInXVsnc2VydmVyX3R5cGUn XSA9PSAncHBhcycpCisgICAgICAgICAgICAgIGlmICghXy5pc1VuZGVmaW5lZChldm5fZGVsZXRl KSAmJiBtLm5vZGVfaW5mb1snc2VydmVyJ11bJ3NlcnZlcl90eXBlJ10gPT0gJ3BwYXMnICYmIG0u aXNOZXcoKSkKICAgICAgICAgICAgICAgICByZXR1cm4gZmFsc2U7CiAgICAgICAgICAgICAgIHJl dHVybiBtLmluU2NoZW1hV2l0aE1vZGVsQ2hlY2suYXBwbHkodGhpcywgW21dKTsKICAgICAgICAg ICAgIH0sCiAgICAgICAgICAgfSx7CiAgICAgICAgICAgICBpZDogJ2V2bnRfdHJ1bmNhdGUnLCBs YWJlbDogZ2V0dGV4dCgnVFJVTkNBVEUnKSwKLSAgICAgICAgICAgIHR5cGU6ICdzd2l0Y2gnLCBn cm91cDogZ2V0dGV4dCgnRXZlbnRzJyksCisgICAgICAgICAgICB0eXBlOiAnc3dpdGNoJywgZ3Jv dXA6IGdldHRleHQoJ0V2ZW50cycpLGRlcHM6IFsnaXNfcm93X3RyaWdnZXInLCAnaXNfY29uc3Ry YWludF90cmlnZ2VyJ10sCiAgICAgICAgICAgICBleHRyYVRvZ2dsZUNsYXNzZXM6ICdwZy1lbC1z bS02JywKICAgICAgICAgICAgIGNvbnRyb2xMYWJlbENsYXNzTmFtZTogJ2NvbnRyb2wtbGFiZWwg cGctZWwtc20tNSBwZy1lbC0xMicsCiAgICAgICAgICAgICBjb250cm9sc0NsYXNzTmFtZTogJ3Bn YWRtaW4tY29udHJvbHMgcGctZWwtc20tNyBwZy1lbC0xMicsCkBAIC00MzksMTggKzQ0NCwxOSBA QCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS50cmlnZ2VyJywgWwogICAgICAgICAgICAgICB2YXIgaXNf Y29uc3RyYWludF90cmlnZ2VyID0gbS5nZXQoJ2lzX2NvbnN0cmFpbnRfdHJpZ2dlcicpLAogICAg ICAgICAgICAgICAgIGlzX3Jvd190cmlnZ2VyID0gbS5nZXQoJ2lzX3Jvd190cmlnZ2VyJyksCiAg ICAgICAgICAgICAgICAgc2VydmVyX3R5cGUgPSBtLm5vZGVfaW5mb1snc2VydmVyJ11bJ3NlcnZl cl90eXBlJ107Ci0gICAgICAgICAgICAgIGlmKCFtLmluU2NoZW1hV2l0aE1vZGVsQ2hlY2suYXBw bHkodGhpcywgW21dKSkgewotICAgICAgICAgICAgICAgIC8vIFdlIHdpbGwgZW5hYmFsZSB0cnVu Y2F0ZSBvbmx5IGZvciBFREIgUFBBUwotICAgICAgICAgICAgICAgIC8vIGFuZCBib3RoIHRyaWdn ZXJzIHJvdyAmIGNvbnN0YXJpbnQgYXJlIHNldCB0byBmYWxzZQotICAgICAgICAgICAgICAgIHJl dHVybiAoc2VydmVyX3R5cGUgIT09ICdwcGFzJyB8fAotICAgICAgICAgICAgICAgIF8uaXNVbmRl ZmluZWQoaXNfY29uc3RyYWludF90cmlnZ2VyKSB8fAotICAgICAgICAgICAgICAgICAgXy5pc1Vu ZGVmaW5lZChpc19yb3dfdHJpZ2dlcikgfHwKLSAgICAgICAgICAgICAgICAgIGlzX2NvbnN0cmFp bnRfdHJpZ2dlciAhPT0gZmFsc2UgfHwKLSAgICAgICAgICAgICAgICAgIGlzX3Jvd190cmlnZ2Vy ICE9PSBmYWxzZSk7Ci0gICAgICAgICAgICAgIH0gZWxzZSB7Ci0gICAgICAgICAgICAgICAgLy8g RGlzYWJsZSBpdAorICAgICAgICAgICAgICBpZiAoaXNfcm93X3RyaWdnZXIgPT0gdHJ1ZSl7Cisg ICAgICAgICAgICAgICAgc2V0VGltZW91dChmdW5jdGlvbigpeworICAgICAgICAgICAgICAgICAg bS5zZXQoJ2V2bnRfdHJ1bmNhdGUnLCBmYWxzZSk7CisgICAgICAgICAgICAgICAgfSwxMCk7CiAg ICAgICAgICAgICAgICAgcmV0dXJuIHRydWU7CiAgICAgICAgICAgICAgIH0KKworICAgICAgICAg ICAgICBpZiAoc2VydmVyX3R5cGUgPT09ICdwcGFzJyAmJgorICAgICAgICAgICAgICAgICAgIV8u aXNVbmRlZmluZWQoaXNfY29uc3RyYWludF90cmlnZ2VyKSAmJgorICAgICAgICAgICAgICAgICAg ICAhXy5pc1VuZGVmaW5lZChpc19yb3dfdHJpZ2dlcikgJiYKKyAgICAgICAgICAgICAgICAgICAg aXNfY29uc3RyYWludF90cmlnZ2VyID09PSBmYWxzZSAmJiBtLmlzTmV3KCkpCisgICAgICAgICAg ICAgICAgcmV0dXJuIGZhbHNlOworICAgICAgICAgICAgICByZXR1cm4gbS5pblNjaGVtYVdpdGhN b2RlbENoZWNrLmFwcGx5KHRoaXMsIFttXSk7CiAgICAgICAgICAgICB9LAogICAgICAgICAgIH1d LAogICAgICAgICB9LHsKQEAgLTU4OCw2ICs1OTQsOCBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS50 cmlnZ2VyJywgWwogICAgICAgICB9LAogICAgICAgICAvLyBEaXNhYmxlL0VuYWJsZSBUcmFuc2l0 aW9uIHRhYmxlcwogICAgICAgICBkaXNhYmxlVHJhbnNpdGlvbjogZnVuY3Rpb24obSkgeworICAg ICAgICAgIGlmICghbS5pc05ldygpKQorICAgICAgICAgICAgcmV0dXJuIHRydWU7CiAgICAgICAg ICAgdmFyIGZsYWcgPSBmYWxzZSwKICAgICAgICAgICAgIGV2bnQgPSBudWxsLAogICAgICAgICAg ICAgbmFtZSA9IHRoaXMubmFtZSwKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy91dGls cy5weSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy91dGlscy5weQppbmRleCAwYzM4MzZmMDguLmRlZWEw YjdlZSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RyaWdnZXJzL3V0aWxzLnB5CisrKyBiL3dlYi9w Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3Rh Ymxlcy90cmlnZ2Vycy91dGlscy5weQpAQCAtMTA1LDYgKzEwNSw3IEBAIGRlZiBnZXRfdHJpZ2dl cl9mdW5jdGlvbl9hbmRfY29sdW1ucyhjb25uLCBkYXRhLCB0aWQsCiAgICAgIyB3aXRoIHNjaGVt YSBuYW1lLgogICAgIGlmIGRhdGFbJ2xhbm5hbWUnXSA9PSAnZWRic3BsJzoKICAgICAgICAgZGF0 YVsndGZ1bmN0aW9uJ10gPSAnSW5saW5lIEVEQi1TUEwnCisgICAgICAgIGRhdGFbJ3RnYXJncydd ID0gTm9uZQogICAgIGVsc2U6CiAgICAgICAgIFNRTCA9IHJlbmRlcl90ZW1wbGF0ZSgiLyIuam9p bigKICAgICAgICAgICAgIFt0ZW1wbGF0ZV9wYXRoLCAnZ2V0X3RyaWdnZXJmdW5jdGlvbnMuc3Fs J10pLAo= --0000000000004c2ee305b216df89--