1. Tiago
  2. Valentina Studio
  3. Mittwoch, November 29 2017, 01:01 PM
  4.  Abonnieren via E-Mail
Hi,

I'm running Valentina Studio 7.5.4 on a mac, and I'm trying to see the materialized views that exist for a Postgres Schema, but I don't find that anywhere (they're not listed under "views";).
Is there a feature to see this? Where can I find it?

Thank you
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Tiago

It should be in the "views" list.

Refresh doesn't help, right?
Anhänge
Kommentar
There are no comments made yet.
Tiago Akzeptierte Antwort
Hi Sergey,
Yes, that was what I thought as well, but the views list is empty (and refresh doesn't help either).

Hello Tiago

It should be in the "views" list.

Refresh doesn't help, right?
Kommentar
There are no comments made yet.
DMITRY IVANOV Akzeptierte Antwort
Today I worked in the materialized views in the version under Windows. I can assure you that there is no such problem. Everything is displayed in the views tree :)
Kommentar
There are no comments made yet.
Tiago Akzeptierte Antwort
So, might this be a problem of the Mac version?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi Tiago,

It works for me on Mac.

What PostgreSQL version are you using?

Here's the query used to get the list of views:

SELECT
cl.oid
, cl.relname AS viewname
, ns.nspname AS SCHEMA
, pg_get_viewdef( cl.oid ) AS definition
, obj_description( cl.oid ) AS COMMENT
, ( CASE
WHEN cl.relkind = 'm'
THEN TRUE
ELSE FALSE
END ) AS "materialized"
, ( CASE
WHEN cl.relkind = 'm'
THEN( SELECT ispopulated FROM pg_matviews WHERE schemaname = ns.nspname AND matviewname = cl.relname )
ELSE FALSE
END ) AS with_data
FROM pg_class cl
JOIN pg_namespace ns
ON ns.oid = relnamespace
AND ( cl.relkind = 'v' OR cl.relkind = 'm' )
AND ns.nspname = 'schema_name'


You can try it to see if materialized views are returned for your schema_name.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories