On Tue, Jan 30, 2018 at 3:22 PM, Melvin Davidson
wrote:
> *>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, index
>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 b
On Tue, Jan 30, 2018 at 2:57 PM, Melvin Davidson
wrote:
>
> *>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:*
>
>
>
>
>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
I'm not sure on this but we have ported this behaviour from pgAdmin3.
May be someone else from the community can explain?
On Tue, Jan 30, 2018 at 4:16 PM, ldrlj1
wrote:
> Interesting... and thank you!
> While I did expect to see tableoid, cmax, xmax, cmin, xmin and ctid in my
> tables... I neve
On Tue, Jan 30, 2018 at 10:46 AM, ldrlj1
wrote:
> 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,
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://w
e PostgreSQL Company
On Mon, Jan 29, 2018 at 8:19 PM, ldrlj1
wrote:
> 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
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
