Some pgAdmin bugs... - Mailing list pgadmin-support

Increment' must be greater than or equal to 1.) Postgres does accept negative increment, so should this dialog.

3) EXEC Script context menu for Procedures works incorrectly - doesn't write the script to the end. An example, procedure with many parameters:

CREATE OR REPLACE PROCEDURE public.dodaj_klijenta(v_naziv character varying,v_oib character varying,v_pdv_id character varying,v_adresa character varying,v_mjesto integer,v_drzava character varying,v_tip_p_sub character varying,v_vlasnik character varying,v_pdv boolean,v_fisk boolean,v_iban character varying,v_k_osoba character varying,v_email character varying,v_br_tel character varying,v_radna_god numeric,v_schema character varying)
...

The EXEC Script for it is generated exactly thus:

CALL public.dodaj_klijenta(<v_naziv character varying>, <v_oib character varyi>

As you can see, it is cut off very early.
A notice, this is only for procedures; EXEC Scripts for functions with many arguments work fine.

4) This one is not a biggie, but it would be nice if it is fixed. Code inserted in the Code tab of the Create/Properties dialog for functions and procedures is put within $BODY$ tags without any newlines. So, if I write a new function/procedure and write this in the editor on the Code tab (shown together with line numbers I see):

1 select * from keyring
2 --some comment

The function is created containing this:

...
AS $BODY$select * from keyring
--tralala$BODY$;
...

Although it apparently doesn't harm the code, it is visually ugly and the syntax-highlighting colors the second line as comment, so the closing $BODY$ appears commented (a bit confusing to see). So to make it look normal, I have to prepend and append a newline:

1 
2 select * from keyring
3 --some comment
4

...to get a more acceptable code:

...
AS $BODY$
select * from keyring
--tralala
$BODY$;
...

So I propose those newlines should be added automatically.


Please advise if I need to report the above problems on Redmine, or perhaps do something else...

-- 
Kind Regards,
Arni Kromić