To: pgadmin-hackers@postgresql.org
From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Subject: Observed bug in pgAdmin3
Message-ID: <568A17FD.5030204@enterprisedb.com>
Date: Mon, 4 Jan 2016 12:28:05 +0530
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------060104030106020802070609"
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

This is a multi-part message in MIME format.
--------------060104030106020802070609
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi All,

I observed an issue while creating new collation (in schemas).

Steps to reproduce,
1) Connect to postgres database
2) Expand 'postgres' database
3) Expand 'schemas'
4) Expand 'Collations'
5) Right click & Click "New Collation..."

Provide > Properties:
   Name: test-11
   Owner: postgres
   Schema: pg_toast

Provide > Definition:
   Copy collation: pg_catalog."en_IN.utf8"

6)
Now click on SQL tab and you will see the wrong sql created, schema name 
is appended twice in alter statement.

CREATE COLLATION pg_toast."test-11" FROM pg_catalog."en_IN.utf8";
ALTER COLLATION *pg_toast."pg_toast.""test-11"""*
   OWNER TO postgres;


Let me know for more information.

Regards,
Murtuza Zabuawala


--------------060104030106020802070609
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hi All,<br>
    <br>
    I observed an issue while creating new collation (in schemas).<br>
    <br>
    Steps to reproduce,<br>
    1) Connect to postgres database<br>
    2) Expand 'postgres' database<br>
    3) Expand 'schemas'<br>
    4) Expand 'Collations'<br>
    5) Right click &amp; Click "New Collation..."<br>
    <br>
    Provide &gt; Properties: <br>
      Name: test-11<br>
      Owner: postgres<br>
      Schema: pg_toast<br>
    <br>
    Provide &gt; Definition:<br>
      Copy collation: pg_catalog."en_IN.utf8"<br>
    <br>
    6)<br>
    Now click on SQL tab and you will see the wrong sql created, schema
    name is appended twice in alter statement.<br>
    <br>
    CREATE COLLATION pg_toast."test-11" FROM pg_catalog."en_IN.utf8";<br>
    ALTER COLLATION <b>pg_toast."pg_toast.""test-11"""</b><br>
      OWNER TO postgres;  <br>
    <br>
    <br>
    Let me know for more information.<br>
    <br>
    Regards,<br>
    Murtuza Zabuawala<br>
    <br>
  </body>
</html>

--------------060104030106020802070609--