Re: [pgadmin-support] Object browser does not show all views

2016-10-14 Thread Johann Spies 

> Please always reply to all, and please keep the pgadmin-support mail in CC
> for better support...

Apologies.  I did not see the Reply-To address was not the list.
> 
> You can see the materialized view in separate collection nodes called
> 'Materialized Views' (and, not in 'Views' collection node).

Another apology. I did not see that and just assumed the same category
as was used by pgadmin3.

Thanks.
Johann

-- 
Johann SpiesTelefoon: 021-808 4699
Databestuurder /  Data manager  Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / 
Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. 
http://www.sun.ac.za/emaildisclaimer


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Object browser does not show all views

2016-10-14 Thread Ashesh Vashi 
[Adding back the pgadmin-support...]

Hi Johann,

Please always reply to all, and please keep the pgadmin-support mail in CC
for better support...

On Fri, Oct 14, 2016 at 1:45 PM, Johann Spies  wrote:

> On Fri, Oct 14, 2016 at 01:34:16PM +0530, Ashesh Vashi wrote:
> > Hi Johann,
> > On Fri, Oct 14, 2016 at 1:22 PM, Johann Spies  wrote:
> >
> > > pgAdmin4 on Debian testing.
> > >
> > > Postgresql 9.5 on the backend.
> > >
> > > There are 36 views in one schema.  The object browser only shows the
> > > last 9 and states that there are 9 views.
> > >
> > Are all these are views, and not materialized view?
> >
>
> Most are materialized views.
>
You can see the materialized view in separate collection nodes called
'Materialized Views' (and, not in 'Views' collection node).


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



*http://www.linkedin.com/in/asheshvashi*


>
> Regards
> Johann
> --
> Johann SpiesTelefoon: 021-808 4699
> Databestuurder /  Data manager  Faks: 021-883 3691
>
> Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
> Centre for Research on Evaluation, Science and Technology
> Universiteit Stellenbosch.
>
> The integrity and confidentiality of this email is governed by these terms
> / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos.
> http://www.sun.ac.za/emaildisclaimer
>

Re: [pgadmin-support] Object browser does not show all views

2016-10-14 Thread Ashesh Vashi 
Hi Johann,
On Fri, Oct 14, 2016 at 1:22 PM, Johann Spies  wrote:

> pgAdmin4 on Debian testing.
>
> Postgresql 9.5 on the backend.
>
> There are 36 views in one schema.  The object browser only shows the
> last 9 and states that there are 9 views.
>
Are all these are views, and not materialized view?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



*http://www.linkedin.com/in/asheshvashi*


>
> How can I be sure that the browser shows everything else?
>
> Regards
> Johann
> --
> Johann SpiesTelefoon: 021-808 4699
> Databestuurder /  Data manager  Faks: 021-883 3691
>
> Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
> Centre for Research on Evaluation, Science and Technology
> Universiteit Stellenbosch.
>
> The integrity and confidentiality of this email is governed by these terms
> / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos.
> http://www.sun.ac.za/emaildisclaimer
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

[pgadmin-support] Object browser does not show all views

2016-10-14 Thread Johann Spies 
pgAdmin4 on Debian testing.

Postgresql 9.5 on the backend.

There are 36 views in one schema.  The object browser only shows the
last 9 and states that there are 9 views.

How can I be sure that the browser shows everything else?

Regards
Johann
-- 
Johann SpiesTelefoon: 021-808 4699
Databestuurder /  Data manager  Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / 
Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. 
http://www.sun.ac.za/emaildisclaimer


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support