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.va...@enterprisedb.com>
Enviado: terça-feira, 5 de maio de 2020 01:01
Para: Edson Richter <edsonrich...@hotmail.com>
Cc: Murtuza Zabuawala <murtuza.zabuaw...@enterprisedb.com>; pgadmin-support
lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Assunto: Re: What does this icon means?
Hi,
On Tue, May 5, 2020 at 5:38 AM Edson Richter
<edsonrich...@hotmail.com<mailto:edsonrich...@hotmail.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,
<edsonrich...@hotmail.com<mailto:edsonrich...@hotmail.com>> wrote:
Kkkkk 🙂
Would the development team create a documentation page describing each icon
used in the object tree?
Thanks,
Edson
________________________________
De: Cherio <che...@gmail.com<mailto:che...@gmail.com>>
Enviado: segunda-feira, 4 de maio de 2020 18:38
Para: Edson Richter <edsonrich...@hotmail.com<mailto:edsonrich...@hotmail.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@lists.postgresql.org<mailto:pgadmin-support@lists.postgresql.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
<edsonrich...@hotmail.com<mailto:edsonrich...@hotmail.com>> wrote:
A small arrow at table icon means what?
[X]
Thanks,
Edson
