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 1kPiEF-0000oA-3O for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Oct 2020 08:21:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kPiEC-0007Oa-NO for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Oct 2020 08:21:44 +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 1kPiEC-0007OT-Hu for pgadmin-hackers@lists.postgresql.org; Tue, 06 Oct 2020 08:21:44 +0000 Received: from mail-pf1-x432.google.com ([2607:f8b0:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kPiE9-0005iQ-N4 for pgadmin-hackers@postgresql.org; Tue, 06 Oct 2020 08:21:43 +0000 Received: by mail-pf1-x432.google.com with SMTP id b26so5240109pff.3 for ; Tue, 06 Oct 2020 01:21:41 -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=Ro7gX0xcjPteWIfhXLCVaA7Br2JtBFZQW9e+L73fxT0=; b=ZFKCpxiU+7MxVbs67QdKk8r+GqGKvtbG4YGPVPo3QZMqJzXUyYRBFUV8vR+jonf55R 85xtCMjmM6+uffMk8/AIeaqt4z+VbMwj/kHNAKtQvYL/FTgLTf1FwjM/7rxoqN/WJjRa vBfr4iD/7ZGHC8NDF2cp2JSioFNILJTIL7YVki978cf3zl4oyHwWz2JXVfeDoMy+l0rA HQPl10o5YK9WTriMq2ItmSYBmYSnglENdqwPpr0ec00PDrgriDqB6A4DciMPmvQ2XzY/ OLIzp6qlfXhbYI4jULW9UGFEK9DvSHKQtTQoVTPywaR2/p6IDPsWhI4BFLEzt/es7AU2 qssA== 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=Ro7gX0xcjPteWIfhXLCVaA7Br2JtBFZQW9e+L73fxT0=; b=XfEfGkDRfeTgLo4tV+s+q4/AIPiMDw9ZRUPHulsJaofIVMS07uLGyMENKCwPO6pTvn NRiGwX6PZGK7qek24VCbu/iMstPSbblEGuIcdB0JSTwNW0kaDF0is8NnKUFO+icYmrZH 2QcqDpjz1PMobLKPo9iH5mGmFWzw6YUt39Am/3suL+bWzVThqrR+h/7IgfmLsSZ9Si7A gtPtrIN82nOldVnIw4vxxML0sUpkAn6ag/butQ+d3bruQV+/1/iOAj37RPSno/4MHYsp q2396oo3C4Tvqcar3dJlZm5yWza/DEzmwdwmViiGUH4YXJZ3atiIZJbXcgw5QdPV0Xko 0NGg== X-Gm-Message-State: AOAM532ODjQHSOdVUK6qel8O73wa61+W12xX32lLOi60k3brT8vZGz01 SuMvbPFOMkgAuYSGuWZUAxrSWw3fN1iatrEeDrd4yHSKMHCozoDrV9XH8X6LBgKDmsXEufaJhkj 4MkzxJm8vu7voZ4jZGFnFHhW2GLa3sWxRO+R5kVVlOiVcio4ZKOMdFGdbN9oozANoglVmIFES0z EZEpbaTig4wqkScXG7MqfcnWA6leHG5+fx0xeyHlenwQ69K8g9V/sklAHQSGcOBQyiFw== X-Google-Smtp-Source: ABdhPJzSH+jbtthbfU8OIQ6FjeB0CRCrFUfxZsCuW8QkQP52mcgt51Ndes/YKNaMqSwjYlkjPFDQsT/Pg+HTwFddy0M= X-Received: by 2002:a62:cf81:0:b029:152:4f70:7d9b with SMTP id b123-20020a62cf810000b02901524f707d9bmr3398237pfg.64.1601972499101; Tue, 06 Oct 2020 01:21:39 -0700 (PDT) MIME-Version: 1.0 From: Pradip Parkale Date: Tue, 6 Oct 2020 13:51:03 +0530 Message-ID: Subject: [pgAdmin][RM5835]: "can't execute an empty query" message displayed if user change the option of Auto FK index ? with No To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000bff61905b0fc4928" 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 --000000000000bff61905b0fc4928 Content-Type: multipart/alternative; boundary="000000000000bff61605b0fc4926" --000000000000bff61605b0fc4926 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is small patch to disable the Auto FK index? option to avoid 'can't execute an empty query' message. -- Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --000000000000bff61605b0fc4926 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,
Attached is small patch t= o disable the Auto FK index? option to avoid 'can't execute an empt= y query' message.

--
Thanks & Regards,
Pradip Pa= rkale
Software Engineer | EnterpriseDB Corporation
--000000000000bff61605b0fc4926-- --000000000000bff61905b0fc4928 Content-Type: application/octet-stream; name="RM5835.patch" Content-Disposition: attachment; filename="RM5835.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kfxp0zgj0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0aWMvanMv Zm9yZWlnbl9rZXkuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3RhdGlj L2pzL2ZvcmVpZ25fa2V5LmpzCmluZGV4IGEwMmVjZjBiNy4uNTQ3ZTNkMTY3IDEwMDY0NAotLS0g YS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3RhdGljL2pzL2ZvcmVpZ25fa2V5 LmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0aWMvanMvZm9y ZWlnbl9rZXkuanMKQEAgLTgxNCw2ICs4MTQsOSBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS5mb3Jl aWduX2tleScsIFsKICAgICAgICAgICAgIG9uVGV4dDogZ2V0dGV4dCgnWWVzJyksCiAgICAgICAg ICAgICBvZmZUZXh0OiBnZXR0ZXh0KCdObycpLAogICAgICAgICAgIH0sZGlzYWJsZWQ6IGZ1bmN0 aW9uKG0pIHsKKyAgICAgICAgICAgIC8vIERvbid0IGFsbG93IHRvIGVkaXQgdGhlIGF1dG8gaW5k ZXggc2V0dGluZyBpbiBlZGl0IG1vZGUKKyAgICAgICAgICAgIGlmKCFtLmlzTmV3KCkpCisgICAg ICAgICAgICAgIHJldHVybiB0cnVlOwogICAgICAgICAgICAgdmFyIGluZGV4ID0gbS5nZXQoJ2Nv dmVyaW5naW5kZXgnKSwKICAgICAgICAgICAgICAgYXV0b2luZGV4ID0gbS5nZXQoJ2F1dG9pbmRl eCcpLAogICAgICAgICAgICAgICBzZXRJbmRleE5hbWUgPSBmdW5jdGlvbigpIHsK --000000000000bff61905b0fc4928--