Some pgAdmin bugs...

From: Arni Kromić <arni(dot)kromic(at)bios-ict(dot)hr>
To: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Some pgAdmin bugs...
Date: 2019-09-10 11:43:18
Message-ID: 48d0e731-09b0-c0c7-49f0-a8cd885875a0@bios-ict.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Working with pgAdmin, I've found several bugs. Not sure if they are
already reported; couldn't find them on Redmine, but perhaps I missed
them. Maybe someone will recognize if they've already been reported.
Here it goes...

1) When doing View/Edit on an empty table, I cannot insert anything when
it opens. There is no empty row I can write into, like there is when a
table has at least one row already. In fact, there are no rows at all,
just the header.

2) Create Sequence dialog doesn't accept negative values for Increment
(Error msg:
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ć

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Arni Kromić 2019-09-10 11:50:51 Re: Some pgAdmin bugs...
Previous Message Dave Page 2019-09-10 11:06:23 Re: Losing column ordering