Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTKCW-0000VE-JF for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jun 2018 04:49:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTKCU-0006uB-By for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jun 2018 04:49:34 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTKCU-0006u1-2B for pgadmin-hackers@lists.postgresql.org; Thu, 14 Jun 2018 04:49:34 +0000 Received: from mail-lf0-x232.google.com ([2a00:1450:4010:c07::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTKCP-0002iy-Qk for pgadmin-hackers@postgresql.org; Thu, 14 Jun 2018 04:49:33 +0000 Received: by mail-lf0-x232.google.com with SMTP id n15-v6so7258847lfn.10 for ; Wed, 13 Jun 2018 21:49:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=RYwk/0nUQqeSp+8UNJ+yHkwdUJVNblxo2LGqwT90ZY0=; b=bERU0FyT7FW01zzFYxEp8AZ1Mexk37PXCXGt2H94y9+Y76izBIURswlfw7xiIlyX1C TwY16xRx/DAHA2hQzh069+ZL6LKZUuzL8HJo1QtI2O6cCeGRNtfQAk9w3s1gWtTdUbOq ziWiymb7KxQsTxCdcO8tiMj5q29/Csyubas0b//salsp/vjO2t7JeUdQUzTFrGWU8VRQ QDxeD2rTZpQCs3RzqZB2mIAeAul2xJtQcD15td++xeUFvwobmF3A8kgAimb0m9IM8wQ5 UHZVo8j7iBDEOX6RYfCr24zjjawAbWobKYtFKZ2Grwe1sZzAXKZmZVPwjOJ6VuqKZBiC Os4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=RYwk/0nUQqeSp+8UNJ+yHkwdUJVNblxo2LGqwT90ZY0=; b=MUApQhYzv8W+K2yPqDnekLdw1ZaIcd0CHe1WlTL+t9WReeACkIPMznJ/Q3JtQFzPzr JXEzLeYJKW9esFH1YgRTTGAwWpEqkuB/lqhSy5RBLlFsl/gLh93wH1WPMB+cr2qcyZiQ HL4zo+dklBJ0+/LCBCMnwpO7mNpPQ6t1NKwV3CVHYtOI2CbgKdFBvljmd4aUTmt5Kv0c Sz9dIHZu7anYh/Au6c7V8ATmG1Tj71YN5NFpnFnpc1D2rzbPPjrIhA0A217mI2IoZWd/ xqzr8qxHylPj7941tEUeVpP02zGJS3l5Ds2orB8hEqhVtHjzc7BFiS853WW7qijp07IR optg== X-Gm-Message-State: APt69E2k3E/yvPtfr7+fxpuDK/y2PWCHVWVRy5Nq3fxkXBI6w7WL+Gtr 4avT3nQsLKkLpg8qv+t6EORxzj7kG5CEhwzivaH7 X-Google-Smtp-Source: ADUXVKKkUddv4hI9tPL4bTPg43eKEGkpRSXT6yosNoiHsUltZkNXlw650dtlWaVJsWyoGnO8DLq3dhYkKnAIRr9JQjA= X-Received: by 2002:a19:16e1:: with SMTP id 94-v6mr4356477lfw.45.1528951767864; Wed, 13 Jun 2018 21:49:27 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ab3:6457:0:0:0:0:0 with HTTP; Wed, 13 Jun 2018 21:49:27 -0700 (PDT) In-Reply-To: References: From: Rushabh Lathia Date: Thu, 14 Jun 2018 10:19:27 +0530 Message-ID: Subject: Re: [PGAGENT] Upgrade pgAgent from unpackaged version To: Dave Page Cc: Ashesh Vashi , pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000000d130056e92d35c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000000d130056e92d35c Content-Type: multipart/alternative; boundary="00000000000000d12c056e92d35a" --00000000000000d12c056e92d35a Content-Type: text/plain; charset="UTF-8" Thanks Ashesh and Dave. I verified the changes and it looks good to me. I found that newly added unpackaged file still have old file header comment. Which require change with new file name. PFA patch to fix the same. Thanks, On Wed, Jun 13, 2018 at 6:10 PM, Dave Page wrote: > Thanks, applied. > > On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi < > ashesh.vashi@enterprisedb.com> wrote: > >> Hi Dave, >> >> As per my conversation with Rushabh, we need to rename the >> pgagent--unpackaged--3.4.sql to pgagent--unpackaged--4.0.sql as it the >> current version has changed. We also need to update the schema version >> function for the unpackaged extension. >> >> Please find the attached patch for the same. >> >> -- >> >> Thanks & Regards, >> >> Ashesh Vashi >> EnterpriseDB INDIA: Enterprise PostgreSQL Company >> >> >> >> *http://www.linkedin.com/in/asheshvashi* >> >> > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- -- Rushabh Lathia Database Architect EnterpriseDB Corporation The Enterprise Postgres Company Phone: +91-20-30589494 Website: http://www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb --00000000000000d12c056e92d35a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Ashesh and Dave.

I verified the changes and it looks good to me.=C2=A0 I found that newl= y
added unpackaged file still have old file header comment.=C2=A0 = Which
require change with new file name.

PFA patch to= fix the same.

Thanks,


On Wed, Jun 13, 2018 at 6:10 PM, Dave Page = <dpage@pgadmin.org> wrote:
Thanks, applied.

On Wed, Jun 13, 2018 at 5:11 = AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Hi Dave,
As per my conversation with Rushabh, we need to rename the= pgagent--unpackaged--3.4.sql to pgagent--unpackaged--4.0.sql as it the cur= rent version has changed. We also need to update the schema version functio= n for the unpackaged extension.

Please find the at= tached patch for the same.

--

Thanks & Regards,<= /span>

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Co= mpany

<= br>

<= a href=3D"http://www.linkedin.com/in/asheshvashi" target=3D"_blank">http= ://www.linkedin.com/in/asheshvashi




--
Dave Page
Blo= g: http://pgsnake= .blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--00000000000000d12c056e92d35a-- --00000000000000d130056e92d35c Content-Type: text/x-patch; charset="US-ASCII"; name="unpackaged_file_header_change.patch" Content-Disposition: attachment; filename="unpackaged_file_header_change.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_jie2ej220 ZGlmZiAtLWdpdCBhL3NxbC9wZ2FnZW50LS11bnBhY2thZ2VkLS00LjAuc3FsIGIvc3FsL3BnYWdl bnQtLXVucGFja2FnZWQtLTQuMC5zcWwKaW5kZXggMzAyZGRlNC4uYjBlMmNjZSAxMDA2NDQKLS0t IGEvc3FsL3BnYWdlbnQtLXVucGFja2FnZWQtLTQuMC5zcWwKKysrIGIvc3FsL3BnYWdlbnQtLXVu cGFja2FnZWQtLTQuMC5zcWwKQEAgLTQsNyArNCw3IEBACiAvLyBDb3B5cmlnaHQgKEMpIDIwMDIg LSAyMDE4IFRoZSBwZ0FkbWluIERldmVsb3BtZW50IFRlYW0KIC8vIFRoaXMgc29mdHdhcmUgaXMg cmVsZWFzZWQgdW5kZXIgdGhlIFBvc3RncmVTUUwgTGljZW5jZQogLy8KLS8vIHBnYWdlbnQtLXVu cGFja2FnZWQtLTMuNC5zcWwgLSBDb252ZXJ0IHBnQWdlbnQgZXhpc3RpbmcgdGFibGVzIGFuZCBm dW5jdGlvbnMgdG8gYW4gZXh0ZW5zaW9uCisvLyBwZ2FnZW50LS11bnBhY2thZ2VkLS00LjAuc3Fs IC0gQ29udmVydCBwZ0FnZW50IGV4aXN0aW5nIHRhYmxlcyBhbmQgZnVuY3Rpb25zIHRvIGFuIGV4 dGVuc2lvbgogLy8KICovCiAK --00000000000000d130056e92d35c--