Home > mailing lists

Thread: What does this icon means?

What does this icon means?

From

Edson Richter

Date:

04 May 2020, 14:17:33

A small arrow at table icon means what?

Thanks,

Edson

Attachment

image.png

Re: What does this icon means?

From

Cherio

Date:

04 May 2020, 21:38:23

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

Attachment

image.png

RE: What does this icon means?

From

Edson Richter

Date:

04 May 2020, 21:55:54

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

Attachment

image.png

Re: What does this icon means?

From

Murtuza Zabuawala

Date:

04 May 2020, 23:54:27

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

Attachment

Re: What does this icon means?

From

Edson Richter

Date:

05 May 2020, 00:07:50

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?

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

Re: What does this icon means?

From

Khushboo Vashi

Date:

05 May 2020, 04:01:46

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

Re: What does this icon means?

From

Aditya Toshniwal

Date:

05 May 2020, 04:03:19

On Tue, May 5, 2020 at 9:32 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

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

And please also check the output of:

select r.relname, r.oid
from pg_inherits i join pg_class r
where i.inhrelid = r.oid

and i.inhparent = <tableoid>;

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

Thanks and Regards,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"

Re: What does this icon means?

From

Akshay Joshi

Date:

05 May 2020, 05:41:40

Hi Edson

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.

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 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

Thanks & Regards

Akshay Joshi

Sr. Software Architect

EnterpriseDB Software India Private Limited

Mobile: +91 976-788-8246

Re: What does this icon means?

From

"Barrington-Hughes, Alan"

Date:

05 May 2020, 13:40:42

My thought is that icon started appearing with the expanded support for partitioned tables, so is this a table that is partitioned or a table that holds partitioned data?

Cheers, Alan
--
Alan Barrington-Hughes
Software Architect
Quality & Regulatory Development
Office: 704.816.5655 | Main: 704.357.0022
alan_barrington-hughes@premierinc.com | Premier, Inc. (NASDAQ: PINC)
Team Award Winner

On May 4, 2020, at 5:55 PM, Edson Richter <edsonrichter@hotmail.com> wrote:

****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****

.
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?

<image.png>

Thanks,

Edson

Re: What does this icon means?

From

Akshay Joshi

Date:

05 May 2020, 14:35:54

Hi All

On Tue, May 5, 2020 at 7:10 PM Barrington-Hughes, Alan <Alan_Barrington-Hughes@premierinc.com> wrote:

My thought is that icon started appearing with the expanded support for partitioned tables, so is this a table that is partitioned or a table that holds partitioned data?

Please check the below screenshot where I have tried to explain the icons used for different types of tables.

Cheers, Alan
--
Alan Barrington-Hughes
Software Architect
Quality & Regulatory Development
Office: 704.816.5655 | Main: 704.357.0022
alan_barrington-hughes@premierinc.com | Premier, Inc. (NASDAQ: PINC)
Team Award Winner

On May 4, 2020, at 5:55 PM, Edson Richter <edsonrichter@hotmail.com> wrote:

****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****

.
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?

<image.png>

Thanks,

Edson

Thanks & Regards

Akshay Joshi

Sr. Software Architect

EnterpriseDB Software India Private Limited

Mobile: +91 976-788-8246

Attachment

Table_Icon.png

Re: What does this icon means?

From

Doug Reed

Date:

05 May 2020, 15:10:08

This IconMap should be added to the Help!

On Tue, May 5, 2020 at 10:36 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:

Hi All

On Tue, May 5, 2020 at 7:10 PM Barrington-Hughes, Alan <Alan_Barrington-Hughes@premierinc.com> wrote:
My thought is that icon started appearing with the expanded support for partitioned tables, so is this a table that is partitioned or a table that holds partitioned data?

Please check the below screenshot where I have tried to explain the icons used for different types of tables.

Cheers, Alan
--
Alan Barrington-Hughes
Software Architect
Quality & Regulatory Development
Office: 704.816.5655 | Main: 704.357.0022
alan_barrington-hughes@premierinc.com | Premier, Inc. (NASDAQ: PINC)
Team Award Winner

On May 4, 2020, at 5:55 PM, Edson Richter <edsonrichter@hotmail.com> wrote:

****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****

.
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?

<image.png>

Thanks,

Edson

--
Thanks & Regards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
Mobile: +91 976-788-8246

Regards,

Doug

Attachment

Table_Icon.png

RE: What does this icon means?

From

Edson Richter

Date:

05 May 2020, 22:27:20

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

RE: What does this icon means?

From

Edson Richter

Date:

05 May 2020, 22:31:39

You guys rules!

This query brought attention to a table that has been used by a DBD to import a spreadsheet into database - and, after, he forgot do delete.

Thank you very much! I'll delete that table now.

Regards,

Edson

De: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Enviado: terça-feira, 5 de maio de 2020 01:03
Para: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Cc: Edson Richter <edsonrichter@hotmail.com>; Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>; pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Assunto: Re: What does this icon means?

On Tue, May 5, 2020 at 9:32 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

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

And please also check the output of:

select r.relname, r.oid
from pg_inherits i join pg_class r
where i.inhrelid = r.oid

and i.inhparent = <tableoid>;

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

Thanks and Regards,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"