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ć
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 |