Postgres Pro
Downloads
Home   >   mailing lists

Fixed issue when clicked on functions inside the package in PPAS - Mailing list pgadmin-hackers

From Akshay Joshi
Subject Fixed issue when clicked on functions inside the package in PPAS
Date
Msg-id CANxoLDc=9Xgq3f=vmviDkDR6F1--J6BEmCUnfAro4PxRpEmFSg@mail.gmail.com
Whole thread Raw
Responses Re: Fixed issue when clicked on functions inside the package in PPAS  (Dave Page <dpage@pgadmin.org>)
List pgadmin-hackers
Tree view
Hi Dave

During some work I have found one issue in pgadmin. When we clicked on functions inside the packages in PPAS it will modify the function name with one of the other function. Attached is the two screenshots. First screenshot has been taken before clicking on each function and second after clicking on each function inside the package.

Steps to reproduce:-  I have created one package on PPAS 9.3 by running following 

CREATE OR REPLACE PACKAGE test_ppas_pkg
IS

  TYPE week_list IS TABLE OF character varying(30) INDEX BY integer;
  TYPE day_list IS TABLE OF character varying(30) INDEX BY integer;

  FUNCTION to_new_dow(p_year_month character varying DEFAULT NULL::character varying) RETURN integer;

  FUNCTION get_date_range(p_year_month character varying, p_week_num integer) RETURN character varying;

  FUNCTION get_week_num(p_the_day character varying) RETURN character varying;

  FUNCTION get_week_of_month(p_year_month character varying) RETURN character varying;

END test_ppas_pkg;

Open pgadmin3 and browse through the package and functions inside the package. Now click on each function, you will see the error.

Attached is the patch file to fix the issue. Can you please review it. If the applied fix looks good to you then can you please commit the code.

--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: wrong current schema in Search Objects dialog box
Next
From: Dave Page
Date:
Subject: pgAdmin III commit: Improve handling of lost connections