Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
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

Re: PGAdmin Version 2.1

2018-01-30 Thread Melvin Davidson
>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

Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
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:* > > > >

Re: PGAdmin Version 2.1

2018-01-30 Thread Melvin Davidson
>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

Re: PGAdmin Version 2.1

2018-01-30 Thread Murtuza Zabuawala
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

Re: PGAdmin Version 2.1

2018-01-30 Thread Dave Page
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,

Re: PGAdmin Version 2.1

2018-01-30 Thread ldrlj1
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

Re: PGAdmin Version 2.1

2018-01-29 Thread Murtuza Zabuawala
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