RE: What does this icon means?

PostgreSQL 9.6 x64 Linux
pgAdmin 4.20 and 4.21
Table DDL:

CREATE TABLE public.mytable
(
guid character varying(36) COLLATE pg_catalog."default" NOT NULL,
textfield_1 character varying(250) COLLATE pg_catalog."default" NOT NULL,
intfield_1 integer NOT NULL,
intfield_2 smallint NOT NULL DEFAULT 0,
intfield_3 smallint NOT NULL DEFAULT 0,
textfield_2 character varying(1000) COLLATE pg_catalog."default",
textfield_3 character varying(10) COLLATE pg_catalog."default",
textfield_4 character varying(250) COLLATE pg_catalog."default",
intfield_4 smallint NOT NULL DEFAULT 0,
intfield_5 smallint NOT NULL DEFAULT 0,
textfield_5 character varying(10) COLLATE pg_catalog."default",
datefield_1 timestamp without time zone,
datefield_2 timestamp without time zone,
intfield_6 integer,
intfield_7 integer,
intfield_8 smallint DEFAULT 0,
intfield_9 smallint DEFAULT 0,
textfield_6 text COLLATE pg_catalog."default",
intfield_10 smallint DEFAULT 0,
CONSTRAINT pkmytable PRIMARY KEY (guid),
CONSTRAINT fk_mytable_codlibera FOREIGN KEY (textfield_5, intfield_1)
REFERENCES public.mytable (textfield_3, intfield_1) MATCH SIMPLE
ON UPDATE CASCADE
ON DELETE RESTRICT,
CONSTRAINT fk_mytable_xyz FOREIGN KEY (intfield_1)
REFERENCES public.xyz (id) MATCH SIMPLE
ON UPDATE CASCADE
ON DELETE CASCADE,
CONSTRAINT fk_mytable_yxz_alteracao FOREIGN KEY (intfield_7)
REFERENCES public.yxz (id) MATCH SIMPLE
ON UPDATE CASCADE
ON DELETE CASCADE,
CONSTRAINT fk_mytable_yxz_criacao FOREIGN KEY (intfield_6)
REFERENCES public.yxz (id) MATCH SIMPLE
ON UPDATE CASCADE
ON DELETE CASCADE
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;

-- Index: uq_mytable

-- DROP INDEX public.uq_mytable;

CREATE UNIQUE INDEX uq_mytable
ON public.mytable USING btree
(intfield_1 ASC NULLS LAST, textfield_3 COLLATE pg_catalog."default" ASC NULLS LAST)
TABLESPACE pg_default;

________________________________

De: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Enviado: terça-feira, 5 de maio de 2020 01:01
Para: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>; pgadmin-support lists.postgresql.org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Assunto: Re: What does this icon means?

Hi,

On Tue, May 5, 2020 at 5:38 AM Edson Richter <edsonrichter(at)hotmail(dot)com<mailto:edsonrichter(at)hotmail(dot)com>> wrote:
Perfect answer! Thanks.
But now I have an issue: this table, for sure, has no inheritance - just because we use no inheritance in this project at all.

Provide some details to investigate the issue.
- PostgreSQL Version
- pgAdmin Version
- if possible, table DDL

Thanks,
Khushboo
What would be causing this?

Atenciosamente,

Edson Richter

Soli Deo Gloria

------ Mensagem original------
De: Murtuza Zabuawala
Data: seg, 4 de mai de 2020 20:54
Para: Edson Richter;
Cc:pgadmin-support lists.postgresql.org<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.postgresql.org%2F&data=02%7C01%7C%7C709c2897e64a4ecd092208d7f0a90cd3%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637242481171982234&sdata=5i%2Ftx3Vw0%2BUK8rbXLOTXh7kefcNpVkjwBfjaIeXc9mA%3D&reserved=0>;
Assunto:Re: What does this icon means?

Hi,

The icon indicates that the table is inherited.

Please refer https://redmine.postgresql.org/issues/3174<https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fredmine.postgresql.org%2Fissues%2F3174&data=02%7C01%7C%7C709c2897e64a4ecd092208d7f0a90cd3%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637242481171992226&sdata=RFL5c4WJ42wIH2jfT7d1%2F%2B37uTLW6bql5nFxIfkc%2FHc%3D&reserved=0> for more details.

Regards,
Murtuza

On Tue, 5 May 2020, 03:26 Edson Richter, <edsonrichter(at)hotmail(dot)com<mailto:edsonrichter(at)hotmail(dot)com>> wrote:
Kkkkk 🙂

Would the development team create a documentation page describing each icon used in the object tree?

Thanks,

Edson

________________________________
De: Cherio <cherio(at)gmail(dot)com<mailto:cherio(at)gmail(dot)com>>
Enviado: segunda-feira, 4 de maio de 2020 18:38
Para: Edson Richter <edsonrichter(at)hotmail(dot)com<mailto:edsonrichter(at)hotmail(dot)com>>
Cc: pgadmin-support lists.postgresql.org<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.postgresql.org%2F&data=02%7C01%7C%7C709c2897e64a4ecd092208d7f0a90cd3%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637242481171992226&sdata=XzrMYXf4L7fAgKOCXxwinRtNnpm5P2SimMORq0Gy8RQ%3D&reserved=0> <pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org>>
Assunto: Re: What does this icon means?

My interpretation is it is telling you which way to look.
Sorry :)

On Mon, May 4, 2020 at 10:17 AM Edson Richter <edsonrichter(at)hotmail(dot)com<mailto:edsonrichter(at)hotmail(dot)com>> wrote:
A small arrow at table icon means what?

[X]

Thanks,

Edson