Postgres Pro
Downloads
Home   >   mailing lists

RE: What does this icon means? - Mailing list pgadmin-support

From Edson Richter
Subject RE: What does this icon means?
Date
Msg-id MN2PR01MB53276CEDF91862DAEE3339C1CFA70@MN2PR01MB5327.prod.exchangelabs.com
Whole thread Raw
In response to Re: What does this icon means?  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
List pgadmin-support
Tree view
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.vashi@enterprisedb.com>
Enviado: terça-feira, 5 de maio de 2020 01:01
Para: Edson Richter <edsonrichter@hotmail.com>
Cc: Murtuza Zabuawala <murtuza.zabuawala@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 <edsonrichter@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;
Assunto:Re: What does this icon means?

Hi,

The icon indicates that the table is inherited.

Please refer https://redmine.postgresql.org/issues/3174 for more details.


Regards,
Murtuza

On Tue, 5 May 2020, 03:26 Edson Richter, <edsonrichter@hotmail.com> wrote:
Kkkkk 🙂

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

Thanks,

Edson

De: Cherio <cherio@gmail.com>
Enviado: segunda-feira, 4 de maio de 2020 18:38
Para: Edson Richter <edsonrichter@hotmail.com>
Cc: pgadmin-support lists.postgresql.org <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 <edsonrichter@hotmail.com> wrote:
A small arrow at table icon means what?



Thanks,

Edson

pgadmin-support by date:

Previous
From:
Date:
Subject: Problems to use LDAP again AD directory with disabled anonymous logon
Next
From: Edson Richter
Date:
Subject: RE: What does this icon means?