MIME-Version: 1.0
From: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
Date: Wed, 13 Jun 2018 09:41:02 +0530
Message-ID: 
 <CAG7mmow-QXT+toi7NwVjj9vdYeH3w9R_jQ=n8GKKX9=sv782vA@mail.gmail.com>
Subject: [PGAGENT] Upgrade pgAgent from unpackaged version
To: Dave Page <dpage@pgadmin.org>
Cc: Rushabh Lathia <rushabh.lathia@enterprisedb.com>,
	pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000fcadcc056e7e2c57"
Precedence: bulk

--000000000000fcadcc056e7e2c57
Content-Type: multipart/alternative; boundary="000000000000fcadc9056e7e2c55"

--000000000000fcadc9056e7e2c55
Content-Type: text/plain; charset="UTF-8"

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.enterprisedb.com>


*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

--000000000000fcadc9056e7e2c55
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Dave,<div><br></div><div>As per my conversation with Ru=
shabh, we need to rename the pgagent--unpackaged--3.4.sql to pgagent--unpac=
kaged--4.0.sql as it the current version has changed. We also need to updat=
e the schema version function for the unpackaged extension.</div><div><br><=
/div><div>Please find the attached patch for the same.</div><div><br clear=
=3D"all"><div><div class=3D"gmail_signature" data-smartmail=3D"gmail_signat=
ure"><div dir=3D"ltr"><div><div dir=3D"ltr"><div style=3D"margin:0pt 0pt 8p=
x"><p style=3D"margin:0pt"><span style=3D"font-family:courier new,monospace=
"><span style=3D"font-style:italic"><span>--</span></span></span></p><p sty=
le=3D"margin:0pt"><span style=3D"font-family:courier new,monospace"><span s=
tyle=3D"font-style:italic"><span>Thanks &amp; Regards,</span></span><br sty=
le=3D"font-style:italic"><br style=3D"font-style:italic"><span style=3D"fon=
t-style:italic">Ashesh Vashi</span><br style=3D"font-style:italic"><span st=
yle=3D"font-style:italic">EnterpriseDB INDIA: </span><a href=3D"http://www.=
enterprisedb.com" target=3D"_blank">Enterprise PostgreSQL Company</a></span=
></p>
<p style=3D"margin:0pt"><span style=3D"font-family:courier new,monospace"><=
br></span></p>
<p style=3D"margin:0pt"><span style=3D"font-family:courier new,monospace"><=
a href=3D"http://www.linkedin.com/in/asheshvashi" target=3D"_blank"><i>http=
://www.linkedin.com/in/asheshvashi</i></a></span></p></div></div></div></di=
v></div></div>
</div></div>

--000000000000fcadc9056e7e2c55--

--000000000000fcadcc056e7e2c57
Content-Type: application/octet-stream;
	name="pgagent_extension_from_unpackaged.sql"
Content-Disposition: attachment;
	filename="pgagent_extension_from_unpackaged.sql"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_jiclke1g0

ZGlmZiAtLWdpdCBhL3NxbC9wZ2FnZW50LS11bnBhY2thZ2VkLS0zLjQuc3FsIGIvc3FsL3BnYWdl
bnQtLXVucGFja2FnZWQtLTQuMC5zcWwKc2ltaWxhcml0eSBpbmRleCA5MCUKcmVuYW1lIGZyb20g
c3FsL3BnYWdlbnQtLXVucGFja2FnZWQtLTMuNC5zcWwKcmVuYW1lIHRvIHNxbC9wZ2FnZW50LS11
bnBhY2thZ2VkLS00LjAuc3FsCmluZGV4IDgxNzk0ZmEuLjMwMmRkZTQgMTAwNjQ0Ci0tLSBhL3Nx
bC9wZ2FnZW50LS11bnBhY2thZ2VkLS0zLjQuc3FsCisrKyBiL3NxbC9wZ2FnZW50LS11bnBhY2th
Z2VkLS00LjAuc3FsCkBAIC0xLDYgKzEsNiBAQAogLyoKIC8vIHBnQWdlbnQgLSBQb3N0Z3JlU1FM
IFRvb2xzCi0vLyAKKy8vCiAvLyBDb3B5cmlnaHQgKEMpIDIwMDIgLSAyMDE4IFRoZSBwZ0FkbWlu
IERldmVsb3BtZW50IFRlYW0KIC8vIFRoaXMgc29mdHdhcmUgaXMgcmVsZWFzZWQgdW5kZXIgdGhl
IFBvc3RncmVTUUwgTGljZW5jZQogLy8KQEAgLTQyLDMgKzQyLDExIEBAIFNFTEVDVCBwZ19jYXRh
bG9nLnBnX2V4dGVuc2lvbl9jb25maWdfZHVtcCgncGdhX3NjaGVkdWxlJywgJycpOwogU0VMRUNU
IHBnX2NhdGFsb2cucGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1wKCdwZ2FfZXhjZXB0aW9uJywgJycp
OwogU0VMRUNUIHBnX2NhdGFsb2cucGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1wKCdwZ2Ffam9ibG9n
JywgJycpOwogU0VMRUNUIHBnX2NhdGFsb2cucGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1wKCdwZ2Ff
am9ic3RlcGxvZycsICcnKTsKKworQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcGdhZ2VudC5w
Z2FnZW50X3NjaGVtYV92ZXJzaW9uKCkgUkVUVVJOUyBpbnQyIEFTICcKK0JFR0lOCisgICAgLS0g
UkVUVVJOUyBQR0FHRU5UIE1BSk9SIFZFUlNJT04KKyAgICAtLSBXRSBXSUxMIENIQU5HRSBUSEUg
TUFKT1IgVkVSU0lPTiwgT05MWSBJRiBUSEVSRSBJUyBBIFNDSEVNQSBDSEFOR0UKKyAgICBSRVRV
Uk4gNDsKK0VORDsKKycgTEFOR1VBR0UgJ3BscGdzcWwnIFZPTEFUSUxFOwo=
--000000000000fcadcc056e7e2c57--