Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bEzhD-00073b-V1 for pgadmin-hackers@arkaria.postgresql.org; Mon, 20 Jun 2016 13:57:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bEzhD-0000xN-5G for pgadmin-hackers@arkaria.postgresql.org; Mon, 20 Jun 2016 13:56:59 +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 1bEzhC-0000xH-Iv for pgadmin-hackers@postgresql.org; Mon, 20 Jun 2016 13:56:58 +0000 Received: from mail-lf0-x22a.google.com ([2a00:1450:4010:c07::22a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bEzh9-0006XA-3T for pgadmin-hackers@postgresql.org; Mon, 20 Jun 2016 13:56:57 +0000 Received: by mail-lf0-x22a.google.com with SMTP id l188so38234427lfe.2 for ; Mon, 20 Jun 2016 06:56:54 -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:date:message-id:subject:from:to; bh=zmGkB/dWAqkd3MIurHAwsUQcxQAz4zUtR8DTrs8RTP0=; b=FGpwrCDCKKIP0jep+Q3iTZQ0amEmyVBxbvXT2WvkAxOQz4l2BQKca4PcFWU2ZvSgtd /jWJb+vuRRB0nd6CnwSGahGnkzZ1tJKyp7/drxXbOGYEFE1MzEE9jvaH9WjqAuW5p4IT K5fagJX6ZuJ/TGRu4kZDaIa4vGKbePiljlvIbC2P3lTnK06Ex/KjufkZPv1WSKynY03l QzGH2/8IlUJOiW7VcsLCgr6L/t67Irp6ZskAGwxOm5QxViORoZZYzIvKo3u59Y9/1QMk Urd2xra7Zyy5by7hvoPMaMXHmbe0Wghtl5kDbnTohnsnPMiYLbP0Z4zzPVrFNWedmAQK RopA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=zmGkB/dWAqkd3MIurHAwsUQcxQAz4zUtR8DTrs8RTP0=; b=I8VSPqlPU3XyZwUGoCLHaAGvFUMNtnTSTaPuHhSSx0QElejIdcLorWULUCAH8AwzaP /mJlHINakUhm+QQJr4HNKRtytydTj87kvLqLHfHAjE+1jQL6eNe3MJMB+LP1sb6LCp/l Yez3cy+XA36sf+3XByLexvNM4ckj2QMCPh3IzSO8jRO3XiTU78+MZKgmkWpfbwl14oeQ /e+lojp7za9l61pCkYQkA7T8LnacTtRXrnMAjWoCACXlm1VVBu03krIr2qb4a+BIDc8G xbY0UPBgsVvWkXY2iBj0Y25JKS/RKY3mwpoI0TUVgnXWNbQdy+IP46uuRRKR9hB4XieS F0FQ== X-Gm-Message-State: ALyK8tIcWsp6GJ0O6sS7T5NdCeDPruDnpQrpF2lcjyhiwshcKoMD3t/hSmFPZHzLCOw/HfY+L3KtyhHUtTxNrGrU MIME-Version: 1.0 X-Received: by 10.25.131.200 with SMTP id f191mr4357822lfd.219.1466431013074; Mon, 20 Jun 2016 06:56:53 -0700 (PDT) Received: by 10.114.173.112 with HTTP; Mon, 20 Jun 2016 06:56:52 -0700 (PDT) In-Reply-To: References: Date: Mon, 20 Jun 2016 19:26:52 +0530 Message-ID: Subject: Re: [pgAdmin 4 - Bug #1292] ERROR: template database "!@#$%^&*()_+{}|:"<>?=-\\][';/.," does not exist message throws if template database contain special charterers From: Sanket Mehta To: pgadmin-hackers Content-Type: multipart/mixed; boundary=001a113e6b069f9b0b0535b6139d X-Pg-Spam-Score: -1.6 (-) 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 --001a113e6b069f9b0b0535b6139d Content-Type: multipart/alternative; boundary=001a113e6b069f9b020535b6139b --001a113e6b069f9b020535b6139b Content-Type: text/plain; charset=UTF-8 Hi, PFA the revised patch to resolve this issue which consists the change in control formatter. Regards, Sanket Mehta Sr Software engineer Enterprisedb On Mon, Jun 13, 2016 at 3:12 PM, wrote: > Issue #1292 has been updated by Dave Page. > > - *Target version* deleted (*1.0 Beta 1*) > > ------------------------------ > Bug #1292: ERROR: template database "!@#$%^&*()_+{}|:"<>?=-\\][';/.," does > not exist message throws if template database contain special charterers > > > - Author: Fahar Abbas > - Status: In Progress > - Priority: Normal > - Assignee: Sanket Mehta > - Category: > - Target version: > > Commit ID: > ----------- > commit 954163b4957c1dce89c0632d009b845cbe90faf4 > > Browser version: > ---------------- > Firefox 45.0.2 > > Python version: > ---------------- > 3.5.1+ > > Platforms: > All > > ERROR: template database "!@#$%^&*()_+{}|:"<>?=-\\][';/.," does not exist > message throws if user try to create database with template database that > name contain special charterers. > > Please note that this issue is not reproducible in other template > databases that name is simple one. > > Please note that this is not reproduce in pgAdmin3. > > Steps: > > 1. Install pgAdmin4 on Ubuntu 16.04 > 2. Install PG-9.6-beta 1 installer > 3. Expand database node > 4. give it's name !#$%^&*()_+{}|:"<>?=-\][';/., > 5. Database created successfully > 6. Again create new database and give it's name abcd > 7. Click on definition tab > 8. select template database !#$%^&*()_+{}|:"<>?=-\][';/., > 9. Click on Save button > Files Screen Shot 2016-06-02 at 10.25.34 am.png > > (1020 KB) > Screen Shot 2016-06-02 at 10.26.01 am.png > > (1.03 MB) > ------------------------------ > > You have received this notification because you have either subscribed to > it, or are involved in it. > To change your notification preferences, please click here: > https://redmine.postgresql.org/my/account > --001a113e6b069f9b020535b6139b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

PFA the revised patch to resolve th= is issue which consists the change in control formatter.


Regards,<= div>Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Jun 13, 2016 at 3:12 PM, <re= dmine@postgresql.org> wrote:

Bug #1292: ERROR: template database "!@#$%^&*()_+{}|= :"<>?=3D-\\][';/.," does not exist message throws if te= mplate database contain special charterers

  • Author: Fahar Abbas
  • Status: In Progress
  • Priority: Normal
  • Assignee: Sanket Mehta
  • Category:
  • Target version:

Commit ID:
-----------
commit 954163b4957c1dce89c0632d009b8= 45cbe90faf4

Browser version:
----------------
Firefox 45.0.2

Python version:
----------------
3.5.1+

Platforms:
All

ERROR: template database "!@#$%^&*()_+{}|:"<>?=3D-\= \][';/.," does not exist message throws if user try to create data= base with template database that name contain special charterers.

Please note that this issue is not reproducible in other template datab= ases that name is simple one.

Please note that this is not reproduce in pgAdmin3.

Steps:

1. Install pgAdmin4 on Ubuntu 16.04
2. Install PG-9.6-beta 1 install= er
3. Expand database node
4. give it's name !#$%^&*()_= +{}|:"<>?=3D-\][';/.,
5. Database created successfully6. Again create new database and give it's name abcd
7. Click on d= efinition tab
8. select template database !#$%^&*()_+{}|:&quo= t;<>?=3D-\][';/.,
9. Click on Save button

Files Screen = Shot 2016-06-02 at 10.25.34 am.png (1020 KB)
Screen = Shot 2016-06-02 at 10.26.01 am.png (1.03 MB)

You have received this notification because you have either subscr= ibed to it, or are involved in it.
To change your notification preferenc= es, please click here: https://redmine.postgresql.org/my/account

--001a113e6b069f9b020535b6139b-- --001a113e6b069f9b0b0535b6139d Content-Type: text/x-patch; charset=US-ASCII; name="RM_1292V2.patch" Content-Disposition: attachment; filename="RM_1292V2.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ipo35xci0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9iYWNrZm9ybS5w Z2FkbWluLmpzIGIvd2ViL3BnYWRtaW4vc3RhdGljL2pzL2JhY2tmb3JtLnBn YWRtaW4uanMKaW5kZXggYzMzMjg5Yy4uNDQ2NmMxYyAxMDA2NDQKLS0tIGEv d2ViL3BnYWRtaW4vc3RhdGljL2pzL2JhY2tmb3JtLnBnYWRtaW4uanMKKysr IGIvd2ViL3BnYWRtaW4vc3RhdGljL2pzL2JhY2tmb3JtLnBnYWRtaW4uanMK QEAgLTE3ODcsNyArMTc4Nyw3IEBACiAgIHZhciBTZWxlY3QyRm9ybWF0dGVy ID0gZnVuY3Rpb24oKSB7fTsKICAgXy5leHRlbmQoU2VsZWN0MkZvcm1hdHRl ci5wcm90b3R5cGUsIHsKICAgICBmcm9tUmF3OiBmdW5jdGlvbihyYXdEYXRh LCBtb2RlbCkgewotICAgICAgcmV0dXJuIEpTT04uc3RyaW5naWZ5KF8uZXNj YXBlKHJhd0RhdGEpKTsKKyAgICAgIHJldHVybiBKU09OLnBhcnNlKEpTT04u c3RyaW5naWZ5KF8uZXNjYXBlKHJhd0RhdGEpKSk7CiAgICAgfSwKICAgICB0 b1JhdzogZnVuY3Rpb24oZm9ybWF0dGVkRGF0YSwgbW9kZWwpIHsKICAgICAg IHJldHVybiBmb3JtYXR0ZWREYXRhOwo= --001a113e6b069f9b0b0535b6139d 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 --001a113e6b069f9b0b0535b6139d--