Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWc2-0006Nc-5K for pgadmin-hackers@arkaria.postgresql.org; Thu, 10 Jan 2019 09:26:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghWbz-0001hr-E8 for pgadmin-hackers@arkaria.postgresql.org; Thu, 10 Jan 2019 09:26:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWbz-0001cc-1E for pgadmin-hackers@lists.postgresql.org; Thu, 10 Jan 2019 09:26:51 +0000 Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWbu-0002Za-FC for pgadmin-hackers@postgresql.org; Thu, 10 Jan 2019 09:26:50 +0000 Received: by mail-qt1-x842.google.com with SMTP id n32so11627223qte.11 for ; Thu, 10 Jan 2019 01:26:45 -0800 (PST) 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=fLKQwg3gHMh6fZwKqAhpNbg6qf29HXJgIk9k4XNnCNY=; b=nSgaMVKO2KTgBpCjD/dF6+hxQEVtdFBsXMSWeJtySdY9EqAzxJCr3EpNb+QFnPORnS iRXkW0fvxweNZs/t/7hlxRD3vebfcez1zo4VZTGf3NoXK1aGOHYM5CFI+PzakjY0uI1N 1rnuSffLU1EOhIwggSZaL4kEExEIVsLD9p6wk6FqXFhsipNwFy9/KW/vEX4CChoJRRaT 9BtCinY3vkoaNBxFdXvJFcZ7WgudwxCrpZ7E4rbYmqHo7PXOrQBD/YOELPNEH7+mAJw3 +lPoMUonu+Uz1ul3XUawXWW2/0PReAee78xA1UNfsyY65MlMjfEnXH5hp8a7g8iEg8vD DgyA== 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=fLKQwg3gHMh6fZwKqAhpNbg6qf29HXJgIk9k4XNnCNY=; b=hAyRfxODvgERFdtIMbHlnuOYwKaaIIAQEBsPdM41oeo3XkBiqXk6v45Kpfa0pqWHDK ufkQ8PnlpyIxPbjerQcCILFXIYLwHnsrFA2aPVFo69uyrOz/MrTMNGJJZPalb7PJVI+a jAEg6zEre9l14A4CEe9kC8NdUqiDH9Hew5NgAdCpVAzquqXmoh7VZQW0gJutgq08U9np FCk3Svw1KFatU0+lDcIh3XdhA8SG7uSHKgbihP0n3tFPXR2m4be2U8TMtB4LyggWmR5+ hjw01mP+dPUAQ+wSASsa0C6pIlvHO79m3RwLrD3l/E00kmKcZJmcX4QEtHbQLF/FFm1z Xo3g== X-Gm-Message-State: AJcUukeqcMS9wAgGaMQHM/k6tXnqmIWr+m/oubuuT5LKhS6fnGEeBwt3 d8nogT2bjQ7/19LawUHdrbrPLQPedp505MhfYGxj5pMQO3TwZA== X-Google-Smtp-Source: ALg8bN6Lu7Vd/J27MAmHVXsefHTfN36FeV/f04oTn9sb1Nedbff2bnhurtZe0DRXmccrETr2Bpv4ANK+te2xYKgcMkI= X-Received: by 2002:a0c:981b:: with SMTP id c27mr9347904qvd.184.1547112403986; Thu, 10 Jan 2019 01:26:43 -0800 (PST) MIME-Version: 1.0 From: Akshay Joshi Date: Thu, 10 Jan 2019 14:56:32 +0530 Message-ID: Subject: [pgAdmin4][Patch] - RM 3505 Incorrect SQL generated for tables created using inherited columns To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000449970057f172d5d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000449970057f172d5d Content-Type: multipart/alternative; boundary="00000000000044996a057f172d5b" --00000000000044996a057f172d5b Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is the patch to fix RM #3505 Incorrect SQL generated for tables created using inherited columns. Please review it. -- *Akshay Joshi* *Sr. Software Architect * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* --00000000000044996a057f172d5b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached is the patch to fix RM #3505 Incorrect SQL generated for = tables created using inherited columns.

Please rev= iew it.

--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9= 517
Mobile: +91 976-788-8246
--00000000000044996a057f172d5b-- --000000000000449970057f172d5d Content-Type: text/x-patch; charset="US-ASCII"; name="RM_3505.patch" Content-Disposition: attachment; filename="RM_3505.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_jqqequa80 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdGFibGUvc3FsL2RlZmF1bHQvY3JlYXRl LnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdGFibGUvc3FsL2RlZmF1bHQvY3JlYXRlLnNxbApp bmRleCA4ZWExYjc2Mi4uODI1MDFhOTEgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMv dGFibGUvc3FsL2RlZmF1bHQvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL3Rh YmxlL3NxbC9kZWZhdWx0L2NyZWF0ZS5zcWwKQEAgLTQxLDEwICs0MSwxMCBAQCBDUkVBVEUgeyUg aWYgZGF0YS5yZWxwZXJzaXN0ZW5jZSAlfVVOTE9HR0VEIHslIGVuZGlmICV9VEFCTEUge3tjb25u fHF0SWRlbnQoZGF0YQogeyMjIyBBZGQgY29sdW1ucyAjIyN9CiB7JSBpZiBkYXRhLmNvbHVtbnMg YW5kIGRhdGEuY29sdW1uc3xsZW5ndGggPiAwICV9CiB7JSBmb3IgYyBpbiBkYXRhLmNvbHVtbnMg JX0KLXslIGlmIGMubmFtZSBhbmQgYy5jbHR5cGUgJX0KLXslIGlmIGxvb3AuaW5kZXggIT0gMSAl fSwKLXslIGVuZGlmICV9Cit7JSBpZiBjLm5hbWUgYW5kIGMuY2x0eXBlIGFuZCBub3QgYy5pbmhl cml0ZWRmcm9tICV9CiAgICAge3tjb25ufHF0SWRlbnQoYy5uYW1lKX19IHslIGlmIGlzX3NxbCAl fXt7Yy5kaXNwbGF5dHlwbmFtZX19eyUgZWxzZSAlfXt7IEdFVF9UWVBFLkNSRUFURV9UWVBFX1NR TChjb25uLCBjLmNsdHlwZSwgYy5hdHRsZW4sIGMuYXR0cHJlY2lzaW9uLCBjLmhhc1NxckJyYWNr ZXQpIH19eyUgZW5kaWYgJX17JSBpZiBjLmNvbGxzcGNuYW1lICV9IENPTExBVEUge3tjLmNvbGxz cGNuYW1lfX17JSBlbmRpZiAlfXslIGlmIGMuYXR0bm90bnVsbCAlfSBOT1QgTlVMTHslIGVuZGlm ICV9eyUgaWYgYy5kZWZ2YWwgJX0gREVGQVVMVCB7e2MuZGVmdmFsfX17JSBlbmRpZiAlfQoreyUg aWYgbm90IGxvb3AubGFzdCAlfSwKK3slIGVuZGlmICV9CiB7JSBlbmRpZiAlfQogeyUgZW5kZm9y ICV9CiB7JSBlbmRpZiAlfQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy90YWJsZS9z cWwvZGVmYXVsdC9zcWwuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy90YWJsZS9zcWwvZGVmYXVs dC9zcWwuc3FsCmRlbGV0ZWQgZmlsZSBtb2RlIDEwMDY0NAppbmRleCAxN2IzNWFlZC4uMDAwMDAw MDAKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy90YWJsZS9zcWwvZGVmYXVsdC9zcWwuc3FsCisr KyAvZGV2L251bGwKQEAgLTEgKzAsMCBAQAotVEFLRSBBU0hFU0gnUyBIRUxQIE9OIFRISVMgVEFT SyA6LSkKXCBObyBuZXdsaW5lIGF0IGVuZCBvZiBmaWxlCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMv dGVtcGxhdGVzL3RhYmxlL3NxbC9ncGRiXzUuMF9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMv dGVtcGxhdGVzL3RhYmxlL3NxbC9ncGRiXzUuMF9wbHVzL2NyZWF0ZS5zcWwKaW5kZXggNjFlNGUx ZTEuLmM4MmU3MmNjIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL3RhYmxlL3NxbC9n cGRiXzUuMF9wbHVzL2NyZWF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy90YWJsZS9z cWwvZ3BkYl81LjBfcGx1cy9jcmVhdGUuc3FsCkBAIC00MSwxMCArNDEsMTAgQEAgQ1JFQVRFIHsl IGlmIGRhdGEucmVscGVyc2lzdGVuY2UgJX1VTkxPR0dFRCB7JSBlbmRpZiAlfVRBQkxFIHt7Y29u bnxxdElkZW50KGRhdGEKIHsjIyMgQWRkIGNvbHVtbnMgIyMjfQogeyUgaWYgZGF0YS5jb2x1bW5z IGFuZCBkYXRhLmNvbHVtbnN8bGVuZ3RoID4gMCAlfQogeyUgZm9yIGMgaW4gZGF0YS5jb2x1bW5z ICV9Ci17JSBpZiBjLm5hbWUgYW5kIGMuY2x0eXBlICV9Ci17JSBpZiBsb29wLmluZGV4ICE9IDEg JX0sCi17JSBlbmRpZiAlfQoreyUgaWYgYy5uYW1lIGFuZCBjLmNsdHlwZSBhbmQgbm90IGMuaW5o ZXJpdGVkZnJvbSAlfQogICAgIHt7Y29ubnxxdElkZW50KGMubmFtZSl9fSB7JSBpZiBpc19zcWwg JX17e2MuZGlzcGxheXR5cG5hbWV9fXslIGVsc2UgJX17eyBHRVRfVFlQRS5DUkVBVEVfVFlQRV9T UUwoY29ubiwgYy5jbHR5cGUsIGMuYXR0bGVuLCBjLmF0dHByZWNpc2lvbiwgYy5oYXNTcXJCcmFj a2V0KSB9fXslIGVuZGlmICV9eyUgaWYgYy5jb2xsc3BjbmFtZSAlfSBDT0xMQVRFIHt7Yy5jb2xs c3BjbmFtZX19eyUgZW5kaWYgJX17JSBpZiBjLmF0dG5vdG51bGwgJX0gTk9UIE5VTEx7JSBlbmRp ZiAlfXslIGlmIGMuZGVmdmFsICV9IERFRkFVTFQge3tjLmRlZnZhbH19eyUgZW5kaWYgJX0KK3sl IGlmIG5vdCBsb29wLmxhc3QgJX0sCit7JSBlbmRpZiAlfQogeyUgZW5kaWYgJX0KIHslIGVuZGZv ciAlfQogeyUgZW5kaWYgJX0K --000000000000449970057f172d5d--