Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Sanket Mehta
Date:
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, <redmine@postgresql.org> 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

FilesScreen 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


Attachment

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

From
Dave Page
Date:
Thanks, patch applied.

On Mon, Jun 20, 2016 at 2:56 PM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
> 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, <redmine@postgresql.org> 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
>
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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

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

From
Murtuza Zabuawala
Date:
Hi,

PFA patch to fix the issue RM#1292. 

Earlier patch was not handling spaces properly.
e.g- If user creates any objects which has spaces in its name then it fails to parse it next time user select it.

  

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jun 20, 2016 at 8:34 PM, Dave Page <dpage@pgadmin.org> wrote:
Thanks, patch applied.

On Mon, Jun 20, 2016 at 2:56 PM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
> 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, <redmine@postgresql.org> 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
>
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Attachment

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

From
Dave Page
Date:
Thanks, applied.

On Fri, Jun 24, 2016 at 12:24 PM, Murtuza Zabuawala
<murtuza.zabuawala@enterprisedb.com> wrote:
> Hi,
>
> PFA patch to fix the issue RM#1292.
>
> Earlier patch was not handling spaces properly.
> e.g- If user creates any objects which has spaces in its name then it fails
> to parse it next time user select it.
>
>
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Mon, Jun 20, 2016 at 8:34 PM, Dave Page <dpage@pgadmin.org> wrote:
>>
>> Thanks, patch applied.
>>
>> On Mon, Jun 20, 2016 at 2:56 PM, Sanket Mehta
>> <sanket.mehta@enterprisedb.com> wrote:
>> > 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, <redmine@postgresql.org> 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
>> >
>> >
>> >
>> >
>> > --
>> > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
>> > To make changes to your subscription:
>> > http://www.postgresql.org/mailpref/pgadmin-hackers
>> >
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> --
>> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-hackers
>
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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

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

From
Harshal Dhumal
Date:
Hi,


This patch has caused another new issue (or regression).

Issue: Select2 control does not work in multi-select mode.

Node affected due to this are Primary key, unique key, and all other node where we have used select2 control in multi-select mode.

Commit id:   4267545e08cb28b8c4574bb7a5da0322ef7728d2







-- 
Harshal Dhumal
Software Engineer

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

On Fri, Jun 24, 2016 at 4:54 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,

PFA patch to fix the issue RM#1292. 

Earlier patch was not handling spaces properly.
e.g- If user creates any objects which has spaces in its name then it fails to parse it next time user select it.

  

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jun 20, 2016 at 8:34 PM, Dave Page <dpage@pgadmin.org> wrote:
Thanks, patch applied.

On Mon, Jun 20, 2016 at 2:56 PM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
> 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, <redmine@postgresql.org> 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
>
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


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

From
Ashesh Vashi
Date:

Can you please look into it?

On Jul 5, 2016 12:42, "Harshal Dhumal" <harshal.dhumal@enterprisedb.com> wrote:
Hi,


This patch has caused another new issue (or regression).

Issue: Select2 control does not work in multi-select mode.

Node affected due to this are Primary key, unique key, and all other node where we have used select2 control in multi-select mode.

Commit id:   4267545e08cb28b8c4574bb7a5da0322ef7728d2







-- 
Harshal Dhumal
Software Engineer

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

On Fri, Jun 24, 2016 at 4:54 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,

PFA patch to fix the issue RM#1292. 

Earlier patch was not handling spaces properly.
e.g- If user creates any objects which has spaces in its name then it fails to parse it next time user select it.

  

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jun 20, 2016 at 8:34 PM, Dave Page <dpage@pgadmin.org> wrote:
Thanks, patch applied.

On Mon, Jun 20, 2016 at 2:56 PM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
> 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, <redmine@postgresql.org> 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
>
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers