Обсуждение: PGAdmin Version 2.1

Hello,
I believe I have found a bug.

OS Windows 7.
Postgres 9.6.5
PGAdmin Version 2.1
  - Python Version 2.7.13
  - Flask Version 0.12.2
  - Application Mode Desktop

When viewing my DB through PGAdmin, it shows I have 233 types. It seems that
PGAdmin is displaying every sequence and table as a type. The create type
command in the SQL window has the tableoid, cmax, xmax, cmin, xmin and ctid
columns as well as table column names. The sequence create type command
shows the same system columns as well as all of the properties of a
sequence.

None of those types show when I execute \dT from psql or when I view types
within PGAdmin 3.




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Interesting... and thank you!
While I did expect to see tableoid, cmax, xmax, cmin, xmin and ctid in my
tables... I never expected turning on "Show system objects" would show
sequences and tables as Postgres Types.

So I am knowledgeable, can you explain why that happens?

Interesting... and thank you!
While I did expect to see tableoid, cmax, xmax, cmin, xmin and ctid in my
tables... I never expected turning on "Show system objects" would show
sequences and tables as Postgres Types.

So I am knowledgeable, can you explain why that happens?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

>Effectively, a composite type that can represent a row in a class

That may be true, but users expect to see "user defined types", not tables and views. As such, the query driving the display should be something like:

WITH types AS
( SELECT reltype
    FROM pg_class
WHERE relkind = 'c'
)
SELECT *
  FROM pg_type
 WHERE oid in (SELECT reltype
                 FROM types)
 ORDER BY typname;

No need to duplicate everything else.

>No - if you switch on "Show system objects", it will display system objects such as row 

>types. That's the whole point of the switch (which is off by default). 

Except that "system objects" are NOT USER tables, views, indexes, etc.

They are _system_ catalogs and views;

Your definition is a behavior change from PgAdmin III, which DID NOT show

every "system object" per your definition". It only showed USER types as per

my query.