Hi Edson On Tue, May 5, 2020 at 5:38 AM Edson Richter <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. > > 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, <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> >> *Enviado:* segunda-feira, 4 de maio de 2020 18:38 >> *Para:* Edson Richter <edsonrich...@hotmail.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@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> >> 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*