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
Hello,
I think you have enabled "Show system objects" option from Preferences
dialog due to which you are able to see them in types.
Could you confirm that by navigating "File" -> "Preferences" -> "Browser"
-> "Display" (Check screenshot for more information), If it is set to
"True" then this not