Re: Observed issue in pgAdmin3 while creating Type object

Sure I'll check.

On 27-Jan-2016 8:36 pm, "Dave Page" <dave.page@enterprisedb.com> wrote:

Hi,

I'm travelling at the moment, and don't have a pgAdmin 3 build
environment (or VMware) on the machine I brought with me. Akshay - can
you help out please? We should figure out the correct behaviour for
pgAdmin 4, and fix pgAdmin 3 as we go.

Thanks!

On Wed, Jan 27, 2016 at 6:14 AM, Murtuza Zabuawala
<murtuza.zabuawala@enterprisedb.com> wrote:
> Hi Dave,
>
> I am trying to create new type, while doing so I observed an issue, which
> I'm not sure if it is correct or not.
>
> Steps to re-produce the issue:
> 1) Create New Type
> 2) Go to Type Tab, Select type "Range"
> 3) Go to Definition Tab:
> - When we select Subtype: "Bit" (Actually it's bit only if we look in actual
> query output but before adding into combo box we apply qtIdent function in
> c++ side hence we get double quotes in cobmo box)
>
> In the background it ran another query to fill up "Subtype operator class"
> combo box as below,
>
> [Debug query from C++ code]
>  #### Subtype operator class query: SELECT opc.opcname, opc.opcintype
>   FROM pg_opclass opc
>   JOIN pg_type typ ON opc.opcintype=typ.oid    AND typ.typname='"bit"'
>   WHERE opc.opcmethod=403
>   ORDER BY opcname
>
> Now the issue is that it added double quotes in query also causing no output
> from query but if remove the double quote and run the query again we get
> opcname and opcinttype for bit subtype from query,
>
> From the above "Subtype operator class" query we use opc.opcintype
> (subtypeoid) to fill  Subtype diff function combo box, but as we did not get
> any result from above query, it generated below query and wrong output which
> is same for every subtype selected from combo box which has double quotes.
>
>       Actual C++ code (dlgType.cpp:741)
>         set = connection->ExecuteSet(
>                   wxT("SELECT proname, nspname\n")
>                   wxT("  FROM pg_proc\n")
>                   wxT("  JOIN pg_namespace n ON n.oid=pronamespace\n")
>                   wxT("  WHERE prorettype=701 ")
>                   wxT("    AND proargtypes='") + subtypeoid + wxT(" ") +
> subtypeoid + wxT("'\n")
>                   wxT("  ORDER BY proname\n"));
>
>
> [Debug query from C++ code]
> ##### Subtype diff function query: SELECT proname, nspname
>   FROM pg_proc
>   JOIN pg_namespace n ON n.oid=pronamespace
>   WHERE prorettype=701     AND proargtypes=' '
>   ORDER BY proname
>
>
> Can you please confirm this behavior, so that I can proceed in pgAdmin4?
>
>
> Regards,
> Murtuza



--
Dave Page
VP, Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake