Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bv0O0-0005LT-ND for pgadmin-hackers@arkaria.postgresql.org; Fri, 14 Oct 2016 11:10:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bv0O0-00077J-0f for pgadmin-hackers@arkaria.postgresql.org; Fri, 14 Oct 2016 11:10:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bv0Nz-00077A-ES for pgadmin-hackers@postgresql.org; Fri, 14 Oct 2016 11:10:47 +0000 Received: from mail-io0-x22e.google.com ([2607:f8b0:4001:c06::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bv0Nw-0002Mb-BT for pgadmin-hackers@postgresql.org; Fri, 14 Oct 2016 11:10:45 +0000 Received: by mail-io0-x22e.google.com with SMTP id q192so117451027iod.0 for ; Fri, 14 Oct 2016 04:10:44 -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=y9Twi7yIcLgpmks3s0XE6nzmKekyIJVSusCyanF+1K8=; b=P1gSk1AhLPckRfIN1Bv69qDZiS7hxZ5RV5ZvgBFdrwESxaRKlzNzTnb9urTZpd403e xbdFABIjYLAs7wmkOPdvoErRIKMVEwX4TOVzdGTZ7mphwNYXURAGeG+AYOtayr8Q5BwW fUxnTxpVCu68nKDFnTjS/d189Ep851OBif3PZkG3FGKy544q8SAhhSJuDY/3NRmXY0F0 DkZj3Wgh25VNpYghcPIj0q2A7BF7Uf5K5jFJ4rCAFtylUUb8QCkNRPpqPFI7rqeXgwrG b8Ee+LM2RU+gNrceibdy3KIMFJNMILOgNx54Bp95RTkNm/W/R/oeo0dfHu53mL76sJyK oYzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=y9Twi7yIcLgpmks3s0XE6nzmKekyIJVSusCyanF+1K8=; b=CadjobakiMFq3D/NJecq3nxSqeyzIcoRfGsHyk+xEQxNjOAv+MjtwiIXb+4diTqlVe uX83as0Rz52Kb1mSFMipL2VeBtSLVAtUm7kQZOrbA/67mLy52ETxIgibkvsCMs/tM+IV dBckJaU7tZCubQIRM4NPCV1yzCvewDoLWGSUVs+5dQd2F3p71J/xqQa4oAoUgYAw9j1C i61U8oA4EUQMmep3X3dDY/J2KYkVTK4QB3EAaf6sPi4B+4C79/dw8mIHZjnFj9NWYVn3 UdvFDTfiVXHJ27IIPHn2+iCJXciancBvcIo1c61gksFmdfpJb9BM+mym4ok3ViMTOU/E va2g== X-Gm-Message-State: AA6/9RlvGbqieXG9mAVTuTjiNxtOrPPhQ0zBOiY94AJLi8wKYvXVSB3JezUQg1rR4kX2va9kI8Z2BDh+5WiiFgdP X-Received: by 10.107.147.67 with SMTP id v64mr11093666iod.60.1476443443227; Fri, 14 Oct 2016 04:10:43 -0700 (PDT) MIME-Version: 1.0 Received: by 10.36.117.84 with HTTP; Fri, 14 Oct 2016 04:10:42 -0700 (PDT) From: Akshay Joshi Date: Fri, 14 Oct 2016 16:40:42 +0530 Message-ID: Subject: [pgAdmin4][Patch]: RM 1847 SQL script generated by pgAdmin 4 to create table has errors. To: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c054604f72059053ed14661 X-Pg-Spam-Score: -1.5 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --94eb2c054604f72059053ed14661 Content-Type: multipart/alternative; boundary=94eb2c054604f72054053ed1465f --94eb2c054604f72054053ed1465f Content-Type: text/plain; charset=UTF-8 Hi All Please find the attached patch to fix the RM #1847 SQL script generated by pgAdmin 4 to create table has errors. -- *Akshay Joshi* *Principal Software Engineer * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* --94eb2c054604f72054053ed1465f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi All

Please find the att= ached patch to fix the RM #1847 SQL script generated by pgAdmin 4 to create= table has errors.


--
Akshay Joshi
Principal So= ftware Engineer=C2=A0
<= b>

Phone: +91 20-3058-9517
Mobile: +91 976-788-8246=
--94eb2c054604f72054053ed1465f-- --94eb2c054604f72059053ed14661 Content-Type: application/octet-stream; name="RM_1847.patch" Content-Disposition: attachment; filename="RM_1847.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iu9oapau0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2NhdGFsb2dfb2JqZWN0cy9j b2x1bW5zL3RlbXBsYXRlcy9jYXRhbG9nX29iamVjdF9jb2x1bW4vc3FsLzku MV9wbHVzL3Byb3BlcnRpZXMuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvY2F0YWxv Z19vYmplY3RzL2NvbHVtbnMvdGVtcGxhdGVzL2NhdGFsb2dfb2JqZWN0X2Nv bHVtbi9zcWwvOS4xX3BsdXMvcHJvcGVydGllcy5zcWwKaW5kZXggYjJjYTI1 NS4uMWJiNzE0NiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvY2F0YWxv Z19vYmplY3RzL2NvbHVtbnMvdGVtcGxhdGVzL2NhdGFsb2dfb2JqZWN0X2Nv bHVtbi9zcWwvOS4xX3BsdXMvcHJvcGVydGllcy5zcWwKKysrIGIvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvY2F0YWxvZ19vYmplY3RzL2NvbHVtbnMvdGVtcGxhdGVzL2Nh dGFsb2dfb2JqZWN0X2NvbHVtbi9zcWwvOS4xX3BsdXMvcHJvcGVydGllcy5z cWwKQEAgLTExLDcgKzExLDcgQEAgU0VMRUNUCiAJaW5ka2V5LCBjb2xsLmNv bGxuYW1lLCBuc3BjLm5zcG5hbWUgYXMgY29sbG5zcG5hbWUgLCBhdHRvcHRp b25zLAogCS0tIFN0YXJ0IHBnQWRtaW40LCBhZGRlZCB0byBzYXZlIHRpbWUg b24gY2xpZW50IHNpZGUgcGFyc2luZwogCUNBU0UgV0hFTiBsZW5ndGgoY29s bC5jb2xsbmFtZSkgPiAwIEFORCBsZW5ndGgobnNwYy5uc3BuYW1lKSA+IDAg IFRIRU4KLQkgIGNvbmNhdChjb2xsLmNvbGxuYW1lLCcuIicsbnNwYy5uc3Bu YW1lLCciJykKKwkgIGNvbmNhdChxdW90ZV9pZGVudChuc3BjLm5zcG5hbWUp LCcuJyxxdW90ZV9pZGVudChjb2xsLmNvbGxuYW1lKSkKIAlFTFNFICcnIEVO RCBBUyBjb2xsc3BjbmFtZSwKIAlDQVNFIFdIRU4gc3RycG9zKGZvcm1hdF90 eXBlKHR5Lm9pZCxhdHQuYXR0dHlwbW9kKSwgJy4nKSA+IDAgVEhFTgogCSAg c3BsaXRfcGFydChmb3JtYXRfdHlwZSh0eS5vaWQsYXR0LmF0dHR5cG1vZCks ICcuJywgMikKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90 ZW1wbGF0ZXMvY29sdW1uL3NxbC85LjFfcGx1cy9wcm9wZXJ0aWVzLnNxbCBi L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvY29sdW1uL3NxbC85 LjFfcGx1cy9wcm9wZXJ0aWVzLnNxbAppbmRleCBiYjk2Y2ZmLi5mYTVjM2Yz IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVz L2NvbHVtbi9zcWwvOS4xX3BsdXMvcHJvcGVydGllcy5zcWwKKysrIGIvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9jb2x1bW4vc3FsLzkuMV9w bHVzL3Byb3BlcnRpZXMuc3FsCkBAIC0xMSw3ICsxMSw3IEBAIFNFTEVDVCBh dHQuYXR0bmFtZSBhcyBuYW1lLCBhdHQuKiwgZGVmLiosIHBnX2NhdGFsb2cu cGdfZ2V0X2V4cHIoZGVmLmFkYmluLCBkZWYuCiAJaW5ka2V5LCBjb2xsLmNv bGxuYW1lLCBuc3BjLm5zcG5hbWUgYXMgY29sbG5zcG5hbWUgLCBhdHRvcHRp b25zLAogCS0tIFN0YXJ0IHBnQWRtaW40LCBhZGRlZCB0byBzYXZlIHRpbWUg b24gY2xpZW50IHNpZGUgcGFyc2luZwogCUNBU0UgV0hFTiBsZW5ndGgoY29s bC5jb2xsbmFtZSkgPiAwIEFORCBsZW5ndGgobnNwYy5uc3BuYW1lKSA+IDAg IFRIRU4KLQkgIGNvbmNhdChxdW90ZV9pZGVudChjb2xsLmNvbGxuYW1lKSwn LicscXVvdGVfaWRlbnQobnNwYy5uc3BuYW1lKSkKKwkgIGNvbmNhdChxdW90 ZV9pZGVudChuc3BjLm5zcG5hbWUpLCcuJyxxdW90ZV9pZGVudChjb2xsLmNv bGxuYW1lKSkKIAlFTFNFICcnIEVORCBBUyBjb2xsc3BjbmFtZSwKIAlDQVNF IFdIRU4gc3RycG9zKGZvcm1hdF90eXBlKHR5Lm9pZCxhdHQuYXR0dHlwbW9k KSwgJy4nKSA+IDAgVEhFTgogCSAgc3BsaXRfcGFydChmb3JtYXRfdHlwZSh0 eS5vaWQsYXR0LmF0dHR5cG1vZCksICcuJywgMikKZGlmZiAtLWdpdCBhL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvY29sdW1uL3NxbC85LjJf cGx1cy9wcm9wZXJ0aWVzLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90 ZW1wbGF0ZXMvY29sdW1uL3NxbC85LjJfcGx1cy9wcm9wZXJ0aWVzLnNxbApp bmRleCBiMzgzNDk2Li4yMmNlZjcxIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90YWJsZXMvdGVtcGxhdGVzL2NvbHVtbi9zcWwvOS4yX3BsdXMvcHJv cGVydGllcy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9jb2x1bW4vc3FsLzkuMl9wbHVzL3Byb3BlcnRpZXMuc3FsCkBAIC0x MSw3ICsxMSw3IEBAIFNFTEVDVCBhdHQuYXR0bmFtZSBhcyBuYW1lLCBhdHQu KiwgZGVmLiosIHBnX2NhdGFsb2cucGdfZ2V0X2V4cHIoZGVmLmFkYmluLCBk ZWYuCiAJaW5ka2V5LCBjb2xsLmNvbGxuYW1lLCBuc3BjLm5zcG5hbWUgYXMg Y29sbG5zcG5hbWUgLCBhdHRvcHRpb25zLAogCS0tIFN0YXJ0IHBnQWRtaW40 LCBhZGRlZCB0byBzYXZlIHRpbWUgb24gY2xpZW50IHNpZGUgcGFyc2luZwog CUNBU0UgV0hFTiBsZW5ndGgoY29sbC5jb2xsbmFtZSkgPiAwIEFORCBsZW5n dGgobnNwYy5uc3BuYW1lKSA+IDAgIFRIRU4KLQkgIGNvbmNhdChxdW90ZV9p ZGVudChjb2xsLmNvbGxuYW1lKSwnLicscXVvdGVfaWRlbnQobnNwYy5uc3Bu YW1lKSkKKwkgIGNvbmNhdChxdW90ZV9pZGVudChuc3BjLm5zcG5hbWUpLCcu JyxxdW90ZV9pZGVudChjb2xsLmNvbGxuYW1lKSkKIAlFTFNFICcnIEVORCBB UyBjb2xsc3BjbmFtZSwKIAlDQVNFIFdIRU4gc3RycG9zKGZvcm1hdF90eXBl KHR5Lm9pZCxhdHQuYXR0dHlwbW9kKSwgJy4nKSA+IDAgVEhFTgogCSAgc3Bs aXRfcGFydChmb3JtYXRfdHlwZSh0eS5vaWQsYXR0LmF0dHR5cG1vZCksICcu JywgMikK --94eb2c054604f72059053ed14661 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --94eb2c054604f72059053ed14661--