Re: What does this icon means?

Hi Edson

On Tue, May 5, 2020 at 5:38 AM Edson Richter <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.
>
> What would be causing this?
>

Run the below query on the database server and check the value of
*is_inherited
*if it is 1 then the table is the parent table.
*Replace the {{ scid }} with schema oid and {{ tid }} with table oid *

SELECT rel.oid, rel.relname AS name,
(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
ORDER BY rel.relname;

>
> 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
> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fredmine.postgresql.org%2Fissues%2F3174&data=02%7C01%7C%7C61e1ff6e87b448fdfac908d7f08682e9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637242332826306125&sdata=gpTj4sVnRBt9c5d9GbJGOTRos0of6jN6F%2FKsosQs57U%3D&reserved=0>
> for more details.
>
>
> Regards,
> Murtuza
>
> On Tue, 5 May 2020, 03:26 Edson Richter, <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>
>> *Enviado:* segunda-feira, 4 de maio de 2020 18:38
>> *Para:* Edson Richter <edsonrichter(at)hotmail(dot)com>
>> *Cc:* pgadmin-support lists.postgresql.org
>> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.postgresql.org%2F&data=02%7C01%7C%7C61e1ff6e87b448fdfac908d7f08682e9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637242332826316120&sdata=MrUmJ4%2BqJlBNrhtSydnL%2BwW1Z9DmGad6GR7q0qnZM8c%3D&reserved=0>
>> <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>
>> wrote:
>>
>> A small arrow at table icon means what?
>>
>>
>>
>> Thanks,
>>
>> Edson
>>
>>

--
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*