Re: [pgAdmin4][RM4037] COMMENTS from inherited fields are not presentwhen seeing generated SQL from a table

Поиск
Список
Период
Сортировка
От Aditya Toshniwal
Тема Re: [pgAdmin4][RM4037] COMMENTS from inherited fields are not presentwhen seeing generated SQL from a table
Дата
Msg-id CAM9w-_kg+kGCT_sRLL3fK_hy=TN_ondiwiDe=zv5TFL1VH57-g@mail.gmail.com
обсуждение исходный текст
Ответ на [pgAdmin4][RM4037] COMMENTS from inherited fields are not presentwhen seeing generated SQL from a table  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Ответы Re: [pgAdmin4][RM4037] COMMENTS from inherited fields are not presentwhen seeing generated SQL from a table  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Hi Hackers,

Just to mention, the patch also fixes RM2627, RM4058.

On Wed, Mar 27, 2019 at 6:25 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Attached is the patch which fixes the issue where comments added in child table on inherited columns where not showing in reverse engineered SQL.

I have also made changes to show column details of inherited columns of table, as well as for "of type" tables similar to pgAdmin3. eg-
CREATE TABLE public.inhactortest
(
-- Inherited from table public.actor: actor_id integer NOT NULL DEFAULT nextval('actor_actor_id_seq'::regclass),
-- Inherited from table public.actor: first_name character varying(45) COLLATE pg_catalog."default" NOT NULL,
-- Inherited from table public.actor: last_name character varying(45) COLLATE pg_catalog."default" NOT NULL,
-- Inherited from table public.test_table: col1 integer,
-- Inherited from table public.test_table: col2 "char",
-- Inherited from table public.test_table: col3 character varying COLLATE pg_catalog."default",
 owncol integer
)
    INHERITS (public.actor, public.test_table)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.inhactortest
    OWNER to postgres;

COMMENT ON COLUMN public.inhactortest.actor_id
    IS 'in child c';
-- 

Kindly review.

Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"


--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Aditya Toshniwal
Дата:
Сообщение: [pgAdmin4][RM4037] COMMENTS from inherited fields are not presentwhen seeing generated SQL from a table
Следующее
От: Khushboo Vashi
Дата:
Сообщение: Re: [pgAdmin4][Patch] - RM 4030 - IDENTITY column not recognised