Re: What does this icon means?

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.

What would be causing this?

    (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE) AS triggercount,
    (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
    (CASE WHEN rel.relkind = 'p' THEN true ELSE false END) AS is_partitioned,
    (SELECT count(1) FROM pg_inherits WHERE inhrelid=rel.oid LIMIT 1) as is_inherits,
    (SELECT count(1) FROM pg_inherits WHERE inhparent=rel.oid LIMIT 1) as is_inherited
    FROM pg_class rel
    WHERE rel.relkind IN ('r','s','t','p') AND rel.relnamespace = {{ scid }}::oid
    AND NOT rel.relispartition
    AND rel.oid = {{ tid }}::OID

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